Sergey thanks again.
I discovered that it was the problem of the VFP run-time library. I re-build the setup files and re-install it in the workstations then it works fine.
Is it required to re-build the rut-time and re-install it for program changes ?
:) Wilfred
>I would look into ODBC driver and it settings.
>
>>We're using Informix SE 7 and VFP6, all workstations are NT4 with SP6 and installed the same ODBC drivers. One more thing is that it could run the commands like: sqlexec, sqlsetprop. I will try to test with all sql* commands and look for a new driver today. Any ideas ?
>>
>>Thank you for your help.
>>
>>>What is the backend DB? Do you have latest ODBC driver installed?
>>>
>>>>Dear all,
>>>>
>>>>I've added a function that use SQLCOLUMN to get the table structure from the remote server recently.
>>>>Some PCs got an error ".. Not enough memory ...". But I think it's not the memory issue because some PCs with less memory could run it properly. The code like:
>>>>
>>>>IF SQLCOLUMNS(nTest,'table1','FOXPRO','tmp_cols') > 0
>>>>....
>>>>
>>>>
>>>>Any clues ?
>>>>Thank you. Wilfred