Error connection Clarion 5.5G and MySQL

Hello !!!

I have a big problem!

I tried to explain it:

I work with Clarion 5.5G and MSACCESS databases.

I have many programs using this duo clarion-MSACCESS connected with
ODBC connections it works perfectly.

I like to change my MSACCESS database to MYSQL 5.0 database, but I
have a problem, a little example:
when I select a client I blocked this client for security and use a
this code to make this process:

CLOSE(TABLE_BLOCK)

OPEN(TABLE_BLOCK)

CLEAR(TABLE_BLOCK)

TABLE_BLOCK{Prop:SQL}='SELECT MAX(Id) from TABLE_BLOCK'
NEXT(TABLE_BLOCKS)
IF ERRORCODE() OR BLO:Id=0 THEN
BLO:Id = 1
ELSE
BLO:Id += 1
END

BLO:NoUser = GLO:Use
BLO:NoModule = GLO:NoModule
BLO:Register = CLIP(Client_Register)
BLOate = today()
BLO:Time = clock()

ADD(TABLE_BLOCKS)
IF ERRORCODE() THEN
message('ADD
|'&error()&'|'&errorcode()&'|'&errorfile()&'|'&fil eerror()&'|'&fileerrorcode(),ICON:EXCLAMATION)
END

RETURN BLO:Id

CLOSE(TABLE_BLOCK)

I record (ADD) the user number, module number, client register, date
and time,
Note: I OPEN and CLOSE the table because a used a Procedure.

When I run the program and select a register for the browser of the
table CLIENT, show this error:

You have an error in your SQL syntax; check the manual that
corresponds to your MySQL server version for
the right syntax to use near
"TABLE_BLOCK"('ID','NOUSER','NOMODULE','REGISTER', 'DATE','TIME')
VALUES
at line 1

And before when I selected another register from other browser and
table assign, show this error:

Record Retrieval Error

Error (You have an error in your SQL syntax: check the manul that
corresponds to your MySQL server
version for the right syntax to use near "CLIENT"A WH) attempting to
access a record from
the CLIENTES file. Returning to previous window.

I use this values for the data types of clarion and mysql:

Clarion Type Picture MySQL Type
LONG @n10_ INT(10)
CTRING(41) @s40 VARCHAR(40)
REAL @n10`2 DOUBLE (15,5)
DATE @D6 DATETIME
TIME @T8 TIME
BYTE @n3 TINYINT(3)

I forget, I used the program MYSQL Migration Toolkit, for emigration
of data to MSACCESS to MySQL.

I don´t know what could be happen, I like to some help.

Thanks, Sorry for my english

Julio

Hi Julio,

Go to the free news.softvelocity.com news group and you will get faster and
more answers.
--
---
Best Regards,
Earl R Coker
ksasales AT machlink DOT com
www.kwiksystems.net
www.kwiksystems.com
www.kwiksystems.net/appshell/index.htm
www.kwiksystems.net/ClarionTemplates.htm (BigTamer(tm) Templates)


<jcpaquot@gmail.com> wrote in message
news:eaf081b7-26dd-40c6-8b66-5d302db46cc5@k13g2000hse.googlegroups.com...
Hello !!!

I have a big problem!

I tried to explain it:

I work with Clarion 5.5G and MSACCESS databases.

I have many programs using this duo clarion-MSACCESS connected with
ODBC connections it works perfectly.

I like to change my MSACCESS database to MYSQL 5.0 database, but I
have a problem, a little example:
when I select a client I blocked this client for security and use a
this code to make this process:

CLOSE(TABLE_BLOCK)

OPEN(TABLE_BLOCK)

CLEAR(TABLE_BLOCK)

TABLE_BLOCK{Prop:SQL}='SELECT MAX(Id) from TABLE_BLOCK'
NEXT(TABLE_BLOCKS)
IF ERRORCODE() OR BLO:Id=0 THEN
BLO:Id = 1
ELSE
BLO:Id += 1
END

BLO:NoUser = GLO:Use
BLO:NoModule = GLO:NoModule
BLO:Register = CLIP(Client_Register)
BLOate = today()
BLO:Time = clock()

ADD(TABLE_BLOCKS)
IF ERRORCODE() THEN
message('ADD
|'&error()&'|'&errorcode()&'|'&errorfile()&'|'&fil eerror()&'|'&fileerrorcode(),ICON:EXCLAMATION)
END

RETURN BLO:Id

CLOSE(TABLE_BLOCK)

I record (ADD) the user number, module number, client register, date
and time,
Note: I OPEN and CLOSE the table because a used a Procedure.

When I run the program and select a register for the browser of the
table CLIENT, show this error:

You have an error in your SQL syntax; check the manual that
corresponds to your MySQL server version for
the right syntax to use near
"TABLE_BLOCK"('ID','NOUSER','NOMODULE','REGISTER', 'DATE','TIME')
VALUES
at line 1

And before when I selected another register from other browser and
table assign, show this error:

Record Retrieval Error

Error (You have an error in your SQL syntax: check the manul that
corresponds to your MySQL server
version for the right syntax to use near "CLIENT"A WH) attempting to
access a record from
the CLIENTES file. Returning to previous window.

I use this values for the data types of clarion and mysql:

Clarion Type Picture MySQL Type
LONG @n10_ INT(10)
CTRING(41) @s40 VARCHAR(40)
REAL @n10`2 DOUBLE (15,5)
DATE @D6 DATETIME
TIME @T8 TIME
BYTE @n3 TINYINT(3)

I forget, I used the program MYSQL Migration Toolkit, for emigration
of data to MSACCESS to MySQL.

I don´t know what could be happen, I like to some help.

Thanks, Sorry for my english

Julio

On 2 ago, 02:50, "Earl R Coker" <ksasales AT machlink DOT com> wrote:
> Hi Julio,
>
> Go to the free news.softvelocity.com news group and you will get faster and
> more answers.
> --
> ---
> Best Regards,
> Earl R Coker
> ksasales AT machlink DOT comwww.kwiksystems.netwww.kwiksystems.comwww.kwiks ystems.net/appshell/index.htmwww.kwiksystems.net/ClarionTemplates.htm(BigTamer(tm) Templates)
>
> <jcpaq...@gmail.com> wrote in message
>
> news:eaf081b7-26dd-40c6-8b66-5d302db46cc5@k13g2000hse.googlegroups.com...
> Hello !!!
>
> I have a big problem!
>
> I tried to explain it:
>
> I work with Clarion 5.5G and MSACCESS databases.
>
> I have many programs using this duo clarion-MSACCESS connected with
> ODBC connections it works perfectly.
>
> I like to change my MSACCESS database to MYSQL 5.0 database, but I
> have a problem, a little example:
> when I select a client I blocked this client for security and use a
> this code to make this process:
>
> * CLOSE(TABLE_BLOCK)
>
> * OPEN(TABLE_BLOCK)
>
> * CLEAR(TABLE_BLOCK)
>
> * TABLE_BLOCK{Prop:SQL}='SELECT MAX(Id) from TABLE_BLOCK'
> * NEXT(TABLE_BLOCKS)
> * IF ERRORCODE() OR BLO:Id=0 THEN
> * * * BLO:Id = 1
> * ELSE
> * * * BLO:Id += 1
> * END
>
> * BLO:NoUser * * = GLO:Use
> * BLO:NoModule * = GLO:NoModule
> * BLO:Register * = CLIP(Client_Register)
> * BLOate * * * = today()
> * BLO:Time * * * = clock()
>
> * ADD(TABLE_BLOCKS)
> * IF ERRORCODE() THEN
> * * message('ADD
> |'&error()&'|'&errorcode()&'|'&errorfile()&'|'&fil eerror()&'|'&fileerrorcode(),ICON:EXCLAMATION)
> * END
>
> * RETURN BLO:Id
>
> * CLOSE(TABLE_BLOCK)
>
> I record (ADD) the user number, module number, client register, date
> and time,
> Note: I OPEN and CLOSE the table because a used a Procedure.
>
> When I run the program and select a register for the browser of the
> table CLIENT, show this error:
>
> You have an error in your SQL syntax; check the manual that
> corresponds to your MySQL server version for
> the right syntax to use near
> "TABLE_BLOCK"('ID','NOUSER','NOMODULE','REGISTER', 'DATE','TIME')
> VALUES
> at line 1
>
> And before when I selected another register from other browser and
> table assign, show this error:
>
> Record Retrieval Error
>
> Error (You have an error in your SQL syntax: check the manul that
> corresponds to your MySQL server
> version for the right syntax to use near "CLIENT"A WH) attempting to
> access a record from
> the CLIENTES file. Returning to previous window.
>
> I use this values for the data types of clarion and mysql:
>
> Clarion Type Picture * *MySQL Type
> LONG * * *@n10_ INT(10)
> CTRING(41) * @s40 VARCHAR(40)
> REAL * * *@n10`2 DOUBLE (15,5)
> DATE * * *@D6 DATETIME
> TIME * * *@T8 TIME
> BYTE * * *@n3 TINYINT(3)
>
> I forget, I used the program MYSQL Migration Toolkit, for emigration
> of data to MSACCESS to MySQL.
>
> I don´t know what could be happen, I like to some help.
>
> Thanks, Sorry for my english
>
> Julio

Thanks Earl, I tried to enter to the site, but I need the User Name
and Password, I don´t have it.

Do you know how I can get in?

Thanks

Julio

> Thanks Earl, I tried to enter to the site, but I need the User Name
> and Password, I don´t have it.

> Do you know how I can get in?

You must be trying a different newsgroup than the one I am talking about.
Use your ISP's FREE newgroup feature and subscribe to the ---
news.softvelocity.com --- newsgroup. There is no name or password
required. There is a name and password required for Soft Velocity's PRIVATE
NEWSGROUP however.
--
---
Best Regards,
Earl R Coker
ksasales AT machlink DOT com
www.kwiksystems.net
www.kwiksystems.com
www.kwiksystems.net/appshell/index.htm
www.kwiksystems.net/ClarionTemplates.htm (BigTamer(tm) Templates)

On Tue, 5 Aug 2008 12:34:44 -0500, "Earl R Coker" <ksasales AT
machlink DOT com> wrote:

>> Thanks Earl, I tried to enter to the site, but I need the User Name
>> and Password, I don´t have it.
>
>> Do you know how I can get in?
>
>You must be trying a different newsgroup than the one I am talking about.
>Use your ISP's FREE newgroup feature and subscribe to the ---
>news.softvelocity.com --- newsgroup. There is no name or password
>required. There is a name and password required for Soft Velocity's PRIVATE
>NEWSGROUP however.

This might be clearer if it were mentioned that the /newsgroup/ is
"comp.lang.clarion" (yes, the same name as this one) on the /server/
"news.softvelocity.com" (and, yes, it does have a lot more traffic).
Oh, and it is the program used to subscribe to newsgroups that needs
to be told to connect to the server and subscribe to the newsgroup.

If the program used for this by the OP cannot handle multiple servers,
Agent can. So can others, no doubt.
--
"A portent, therefore, happens not contrary to nature,
but contrary to what we know as nature."

On 1 Aug., 17:32, jcpaq...@gmail.com wrote:
> Hello !!!
>
> I have a big problem!
>
> I tried to explain it:
>
> I work with Clarion 5.5G and MSACCESS databases.
>
> I have many programs using this duo clarion-MSACCESS connected with
> ODBC connections it works perfectly.
>
> I like to change my MSACCESS database to MYSQL 5.0 database, but I
> have a problem, a little example:
> when I select a client I blocked this client for security and use a
> this code to make this process:
>
> * CLOSE(TABLE_BLOCK)
>
> * OPEN(TABLE_BLOCK)
>
> * CLEAR(TABLE_BLOCK)
>
> * TABLE_BLOCK{Prop:SQL}='SELECT MAX(Id) from TABLE_BLOCK'
> * NEXT(TABLE_BLOCKS)
> * IF ERRORCODE() OR BLO:Id=0 THEN
> * * * BLO:Id = 1
> * ELSE
> * * * BLO:Id += 1
> * END
>
> * BLO:NoUser * * = GLO:Use
> * BLO:NoModule * = GLO:NoModule
> * BLO:Register * = CLIP(Client_Register)
> * BLOate * * * = today()
> * BLO:Time * * * = clock()
>
> * ADD(TABLE_BLOCKS)
> * IF ERRORCODE() THEN
> * * message('ADD
> |'&error()&'|'&errorcode()&'|'&errorfile()&'|'&fil eerror()&'|'&fileerrorcode(),ICON:EXCLAMATION)
> * END
>
> * RETURN BLO:Id
>
> * CLOSE(TABLE_BLOCK)
>
> I record (ADD) the user number, module number, client register, date
> and time,
> Note: I OPEN and CLOSE the table because a used a Procedure.
>
> When I run the program and select a register for the browser of the
> table CLIENT, show this error:
>
> You have an error in your SQL syntax; check the manual that
> corresponds to your MySQL server version for
> the right syntax to use near
> "TABLE_BLOCK"('ID','NOUSER','NOMODULE','REGISTER', 'DATE','TIME')
> VALUES
> at line 1
>
> And before when I selected another register from other browser and
> table assign, show this error:
>
> Record Retrieval Error
>
> Error (You have an error in your SQL syntax: check the manul that
> corresponds to your MySQL server
> version for the right syntax to use near "CLIENT"A WH) attempting to
> access a record from
> the CLIENTES file. Returning to previous window.
>
> I use this values for the data types of clarion and mysql:
>
> Clarion Type Picture * *MySQL Type
> LONG * * * * @n10_ * * *INT(10)
> CTRING(41) * @s40 * * * VARCHAR(40)
> REAL * * * * @n10`2 * * DOUBLE (15,5)
> DATE * * * * @D6 * * * *DATETIME
> TIME * * * * @T8 * * * *TIME
> BYTE * * * * @n3 * * * *TINYINT(3)
>
> I forget, I used the program MYSQL Migration Toolkit, for emigration
> of data to MSACCESS to MySQL.
>
> I don´t know what could be happen, I like to some help.
>
> Thanks, Sorry for my english
>
> Julio

Hi Julio,
may be that DATE and TIME are reseved word for in that database?

hth
Rudolf

On 8 ago, 08:59, "rudolf.kreut...@gmail.com"
<rudolf.kreut...@gmail.com> wrote:
> On 1 Aug., 17:32, jcpaq...@gmail.com wrote:
>
>
>
> > Hello !!!
>
> > I have a big problem!
>
> > I tried to explain it:
>
> > I work with Clarion 5.5G and MSACCESS databases.
>
> > I have many programs using this duo clarion-MSACCESS connected with
> > ODBC connections it works perfectly.
>
> > I like to change my MSACCESS database to MYSQL 5.0 database, but I
> > have a problem, a little example:
> > when I select a client I blocked this client for security and use a
> > this code to make this process:
>
> > * CLOSE(TABLE_BLOCK)
>
> > * OPEN(TABLE_BLOCK)
>
> > * CLEAR(TABLE_BLOCK)
>
> > * TABLE_BLOCK{Prop:SQL}='SELECT MAX(Id) from TABLE_BLOCK'
> > * NEXT(TABLE_BLOCKS)
> > * IF ERRORCODE() OR BLO:Id=0 THEN
> > * * * BLO:Id = 1
> > * ELSE
> > * * * BLO:Id += 1
> > * END
>
> > * BLO:NoUser * * = GLO:Use
> > * BLO:NoModule * = GLO:NoModule
> > * BLO:Register * = CLIP(Client_Register)
> > * BLOate * * * = today()
> > * BLO:Time * * * = clock()
>
> > * ADD(TABLE_BLOCKS)
> > * IF ERRORCODE() THEN
> > * * message('ADD
> > |'&error()&'|'&errorcode()&'|'&errorfile()&'|'&fil eerror()&'|'&fileerrorcode(),ICON:EXCLAMATION)
> > * END
>
> > * RETURN BLO:Id
>
> > * CLOSE(TABLE_BLOCK)
>
> > I record (ADD) the user number, module number, client register, date
> > and time,
> > Note: I OPEN and CLOSE the table because a used a Procedure.
>
> > When I run the program and select a register for the browser of the
> > table CLIENT, show this error:
>
> > You have an error in your SQL syntax; check the manual that
> > corresponds to your MySQL server version for
> > the right syntax to use near
> > "TABLE_BLOCK"('ID','NOUSER','NOMODULE','REGISTER', 'DATE','TIME')
> > VALUES
> > at line 1
>
> > And before when I selected another register from other browser and
> > table assign, show this error:
>
> > Record Retrieval Error
>
> > Error (You have an error in your SQL syntax: check the manul that
> > corresponds to your MySQL server
> > version for the right syntax to use near "CLIENT"A WH) attempting to
> > access a record from
> > the CLIENTES file. Returning to previous window.
>
> > I use this values for the data types of clarion and mysql:
>
> > Clarion Type Picture * *MySQL Type
> > LONG * * * * @n10_ * * *INT(10)
> > CTRING(41) * @s40 * * * VARCHAR(40)
> > REAL * * * * @n10`2 * * DOUBLE (15,5)
> > DATE * * * * @D6 * * * *DATETIME
> > TIME * * * * @T8 * * * *TIME
> > BYTE * * * * @n3 * * * *TINYINT(3)
>
> > I forget, I used the program MYSQL Migration Toolkit, for emigration
> > of data to MSACCESS to MySQL.
>
> > I don´t know what could be happen, I like to some help.
>
> > Thanks, Sorry for my english
>
> > Julio
>
> Hi Julio,
> may be that DATE and TIME are reseved word for in that database?
>
> hth
> Rudolf

Hello Rudolf

NO, I use DATE and TIME to example I used in my tps an Mysql

BLO:NoUser = GLO:Use
BLO:NoModule = GLO:NoModule
BLO:Register = CLIP(Client_Register)
!wrong example
! BLOate = today() <-
! BLO:Time = clock() <-

!Right
BLO:Fecha = today()
BLO:Hora = clock()

I hope your have another solution, thanks

Julio