Hi everybody, Please I need help on this.

I am beginning a new application. I am doing it with VB 6.0   -   MySQL 5.0   - 
  MyODBC 3.51   on Windows 

Is there any parameter  i need to establish in order to be able to work with 
RecordSets in the Client side ????, actually i  can't because if i do, when i 
change  any value   i receive the following message:

Error '-2147217900 (80040e14) en tiempo de ejecucion:

[MySQL][ODBC 3.51 Driver][mysqld-5.0.15]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'. ´catpartes´ SET ´condicion´ =2 WHERE ´CveCia´ =1 and 
´Almacen´ ='01' and ´NoParte´ at line 1


If i change the CursorLocation to 3 - adUseClient i don't receive the above 
message and the information is updated correctly . But with the CursorLocation 
2 - adUseServer the DataList, DataCombo and DataGrid dont work.

Thanks in advance.



                
---------------------------------
  Do You Yahoo!? La mejor conexión a Internet y 2GB extra a tu correo por $100 
al mes. http://net.yahoo.com.mx 

Reply via email to