Recent content by gabrielk10

The field is a string(8), i tried with the single quotesand already is running without error. Im using Visual Basic and this is the query: "SELECT UM_PART, UM_UM, UM_ALT_UM, UM_CONV FROM pub.UM_MSTR WHERE UM_UM='KG' AND UM_PART=" & "'" & CStr(RsPARTIDA!SOD_PART) & "'" & " AND UM_ALT_UM=" & "'"...

HI, i have a problem and i need help with an ODBC errror, im working with Merant 3.6 and Progress 9.1D . I have this queries "SELECT * FROM pub.UM_MSTR ORDER BY UM_PART " "SELECT pub.UM_MSTR.UM_PART,pub.UM_MSTR.UM_UM,pub.UM_MSTR.UM_ALT_UM,pub.UM_MSTR.UM_CONV FROM pub.UM_MSTR" this works fine...

Hi, i have a problem with array fields , i would to access in a array field named "cmmt" , This field content 15 arrays , but i just need consultings the first and second arrays with a SQL sentence like this: SELECT CMT_INDX, CMT_CMMT[1], CMT_CMMT[2] FROM CMT_DET WHERE CMT_INDX= "VBCMTINDEX"...

Excellent vinod_home!!!. I follow the steps and it really works. Thanks. Cheers.

Hi, I'm trying to run a local database on Windows 7 , I've a batch file that contain this: REM Script to start database server. REM tokens: REM &DLC = Progress Directory REM &LOOP-DB-START = start of database loop REM &LOOP-DB-END = end of database loop REM &START-SERVER = command line to...

How can I to delete an inactive user because person whom belongs that user he's not more working with us and we have another user in the same situations and for this reason i would like erase them. When a try to delete any user MFG/pro sen a message "Cannot delete user.Active user" and all these...