Search found 35 matches
- Tue Sep 06, 2022 7:39 am
- Forum: VO & Vulcan
- Topic: SQLtable & MySql: Problem with Seek & Assign
- Replies: 14
- Views: 2661
SQLtable & MySql: Problem with Seek & Assign
<t>Hi,<br/> I know that the best way is to migrate to SQL (and this is my goal), but i was investigating a shortcut to replace DBF with MySQL without relevant code modification.<br/> SQLTable/SQLSelect seem not to be the best way for me, so i'll continue with my previos way, editing every single ...
- Mon Sep 05, 2022 10:31 am
- Forum: VO & Vulcan
- Topic: SQLtable & MySql: Problem with Seek & Assign
- Replies: 14
- Views: 2661
SQLtable & MySql: Problem with Seek & Assign
<t>Thanks Jamal,<br/> but i've the same problem even using your suggestion.<br/> <br/> I've found out that the problem seem to be SQLTable.<br/> Using SQLSelect seem to work, but obviously orderby and SetRelation are not available, and in the past whe used it very often.<br/> <br/> Anyone has a clue ...
- Fri Sep 02, 2022 7:57 am
- Forum: VO & Vulcan
- Topic: SQLtable & MySql: Problem with Seek & Assign
- Replies: 14
- Views: 2661
SQLtable & MySql: Problem with Seek & Assign
Hi Wolfgang,
I used the cavo Menu->Tools->SQL Editor.
It creted the class inheriting SQLTable
CLASS ArticokSQL INHERIT SQLTable
Regards
Gianluca
I used the cavo Menu->Tools->SQL Editor.
It creted the class inheriting SQLTable
CLASS ArticokSQL INHERIT SQLTable
Regards
Gianluca
- Thu Sep 01, 2022 11:12 am
- Forum: VO & Vulcan
- Topic: SQLtable & MySql: Problem with Seek & Assign
- Replies: 14
- Views: 2661
SQLtable & MySql: Problem with Seek & Assign
<r>Hello,<br/> SQLtable connect via ODBC to MySQL db, so no VO SQL class is involved.<br/> I can update the record used in the sample code both using Workbench (UPDATE articok SET etic='' WHERE codice='0001009') and with the following code, updating every record in the table:<br/> <br ...
- Thu Sep 01, 2022 8:35 am
- Forum: VO & Vulcan
- Topic: SQLtable & MySql: Problem with Seek & Assign
- Replies: 14
- Views: 2661
SQLtable & MySql: Problem with Seek & Assign
<r>Hello Dick,<br/> the error fires when Skip is invoked, and in every record.<br/> Just to test i've replaced the empty value with 'X' but the rerult is the same<br/> <br/> ***************************************************************<br/> local oDBArticok as ArticokSQL <br/> <br/> oDBArticok ...
- Wed Aug 31, 2022 4:53 pm
- Forum: VO & Vulcan
- Topic: SQLtable & MySql: Problem with Seek & Assign
- Replies: 14
- Views: 2661
SQLtable & MySql: Problem with Seek & Assign
<r>Hi,<br/> to speedup the migration from DBF to MySQL I'm tryng to replace DBserver with SQLtable in CAVO 2.8sp4.<br/> I'm having some trouble assigning value to a field, but <B><s>[b]</s>only<e>[/b]</e></B> after a seek.<br/> this is my test code:<br/> <br ...
- Wed Oct 02, 2019 8:33 am
- Forum: Forum Italiano
- Topic: Formattazione di una data
- Replies: 2
- Views: 2979
Formattazione di una data
<t>Ciao a tutti,<br/> ieri ricompilando un progetto dopo l'installazione della versione 2.07 (ma non sono sicuro sia questa la causa del problema) ho cominciato ad avere un errore che riguarda la seguente riga:<br/> <br/> sQuery := i"UPDATE infoart SET vecchiocos=oldcos_1,cambiocost='{dData:yyyy-MM ...
- Tue Apr 30, 2019 4:29 pm
- Forum: Chit-Chat
- Topic: system.data.dll Error
- Replies: 5
- Views: 2053
system.data.dll Error
<r>Hi Again,<br/> we found out it was a OS problem.<br/> Another software give the same error (see attached image)<br/> <ATTACHMENT filename="rossi giuseppe error framework.png" index="0"><s>[attachment=0]</s>rossi giuseppe error framework.png<e>[/attachment]</e></ATTACHMENT> I know this is not the ...
- Tue Apr 30, 2019 3:44 pm
- Forum: Chit-Chat
- Topic: system.data.dll Error
- Replies: 5
- Views: 2053
system.data.dll Error
Hi Jamal,
I'm still using VS2015.
All my applications are x86
Regards
Gianluca
I'm still using VS2015.
All my applications are x86
Regards
Gianluca
- Tue Apr 30, 2019 2:42 pm
- Forum: Chit-Chat
- Topic: system.data.dll Error
- Replies: 5
- Views: 2053
system.data.dll Error
<r>Hi to all,<br/> I've a strange problem on a Windows 10 Build 17763.379.<br/> Trying to connect to MySQL 5.1 using MySql.Data.dll (Framework 4.0) I have this error:<br/> <br/> [from my error log file:]<br/> <COLOR color="red"><s>[color=red]</s>***********************ERROR ...