Recent content by zazzi

They deal with the possibility to send to MariaDB multiple lines with TEXT....ENDTEXT and use the LOAD DATA LOCAL INFILE command to upload a csv file into a MariaDB database table. See...

If this can help here is my connection working perfectly on my Win11 local development MariaDB: cConnectionString = "DRIVER={MariaDB ODBC 3.2 Driver};" ; + "SERVER=127.0.0.1;" ; + "PORT=3306;" ; + "OPTION=67108864;" ; + "UID=[put your userid here];" ; + "PWD=[put your...

You can use CAST() to force the output field type e.g. in SQL passthrough: SELECT CAST(field_returned_as_memo AS VARCHAR(100)) field_returned_as_varchar from MyTable

You can put null as I showed above or any value you like, try: SELECT custno, SPACE(3) as type, SPACE(10) as bill_stat, CAST(null as n(5,2)) as numbs from test123 WHERE resto='5103' SELECT custno, SPACE(3) as type, SPACE(10) as bill_stat, CAST(123 as n(5,2)) as numbs from test123 WHERE...

You may use: SELECT custno, SPACE(3) as type, SPACE(10) as bill_stat, 000.00 as numbs from test123 WHERE resto='5103' or SELECT custno, SPACE(3) as type, SPACE(10) as bill_stat, CAST(null as n(5,2)) as numbs from test123 WHERE resto='5103' if you like to have a default null value

Examples: ? ALLTRIM(STR(CTOT('21/01/2025 18:00:00') - CTOT('21/01/2025 17:00:00'))) + ' seconds' ? ALLTRIM(STR((CTOT('21/01/2025 18:00:00') - CTOT('21/01/2025 17:00:00')) / 60)) + ' minutes' ? ALLTRIM(STR((CTOT('21/01/2025 18:00:00') - CTOT('21/01/2025 17:00:00')) / 60 / 60)) + ' hours' Adjust...

Solved! It seems adding OPTION 67108864 (MULTI_STATEMENTS) in the connection string OPTION parameter did the trick. In my last post I mentioned error 1050 but that was my fault (forgot to drop the fake table manually). To summarize for all those who may benefit; To enable multiple commands...

Thanks Chris, The example was just an example, my commands are totally different but I used a couple of UPDATE statements just to make it clear to read... It is about dropping a table and building a new one as part of a routine maintenance. I added option 67108864 (MULTI_STATEMENTS) in the...

It does not execute anything. It throws an error "[MySQL][ODBC 8.0(a) Driver][mysqld-11.5.2-MariaDB]You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'UPDATE table2`". So it seems it is reading the two commands...

Tom, If I write this outside VFP (in an HeidiSql query window), it works (and definitely needs the ; ) UPDATE table1 SET column1 = 'aaa'; UPDATE table2 SET column1 = 'bbb'; but it does not work when sent by VFP within TEXT...ENDTEXT

Thanks Joe, I tried but it did not work, I see GO is a command specific to MS SQL server but not allowed for MySql.

I am successfully using TEXT....ENDTEXT to send single commands to a MySql backend. My question is whether it is possible to send multiple commands with one TEXT...ENDTEXT construct (probably not?). Example : ** connection to MySql already verified and labelled as "nH_LS" The following works...

...forgot the important thing! I used it with VFP8... Maurizio Zazzi

Just to say thet I recently used the MS program indicated by keepingbusy for a very large MDB with many tables also including memo fields and everything worked well. You can use the program as is, just changing the name of the dbc to be created and probably a folder that will contain it...

Monika & Mike, note that both ADD COLUMN and DROP COLUMN do support multiple fields: ALTER TABLE myTable ADD COLUMN name c(2) ADD COLUMN name1 c(2) ADD COLUMN name2 c(2) ALTER TABLE myTable DROP COLUMN name DROP COLUMN name1 Maurizio Zazzi