Search found 35 matches

by gianluca.pinoli
Tue Sep 06, 2022 7:39 am
Forum: VO & Vulcan
Topic: SQLtable & MySql: Problem with Seek & Assign
Replies: 14
Views: 2173

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 fun...
by gianluca.pinoli
Mon Sep 05, 2022 10:31 am
Forum: VO & Vulcan
Topic: SQLtable & MySql: Problem with Seek & Assign
Replies: 14
Views: 2173

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...
by gianluca.pinoli
Fri Sep 02, 2022 7:57 am
Forum: VO & Vulcan
Topic: SQLtable & MySql: Problem with Seek & Assign
Replies: 14
Views: 2173

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
by gianluca.pinoli
Thu Sep 01, 2022 11:12 am
Forum: VO & Vulcan
Topic: SQLtable & MySql: Problem with Seek & Assign
Replies: 14
Views: 2173

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/> ************...
by gianluca.pinoli
Thu Sep 01, 2022 8:35 am
Forum: VO & Vulcan
Topic: SQLtable & MySql: Problem with Seek & Assign
Replies: 14
Views: 2173

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 := ...
by gianluca.pinoli
Wed Aug 31, 2022 4:53 pm
Forum: VO & Vulcan
Topic: SQLtable & MySql: Problem with Seek & Assign
Replies: 14
Views: 2173

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/> ***************************************...
by gianluca.pinoli
Wed Oct 02, 2019 8:33 am
Forum: Forum Italiano
Topic: Formattazione di una data
Replies: 2
Views: 2853

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-...
by gianluca.pinoli
Tue Apr 30, 2019 4:29 pm
Forum: Chit-Chat
Topic: system.data.dll Error
Replies: 5
Views: 1869

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 ...
by gianluca.pinoli
Tue Apr 30, 2019 3:44 pm
Forum: Chit-Chat
Topic: system.data.dll Error
Replies: 5
Views: 1869

system.data.dll Error

Hi Jamal,
I'm still using VS2015.
All my applications are x86

Regards
Gianluca
by gianluca.pinoli
Tue Apr 30, 2019 2:42 pm
Forum: Chit-Chat
Topic: system.data.dll Error
Replies: 5
Views: 1869

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**************************...