... USER "userx" PASSWORD "passx" DB "xDb" oDbSend:=oSvr:Rowset("select codigo,data1,data2 from table1 where condition") nTotal:=oDbSend:RecCount() If nTotal > 0 For x=1 to nTotal oRem:Execute( ...
Hola, es tan sencillo como : CREATE TEMPORARY TABLE IF NOT EXISTS table2 AS (SELECT * FROM table1) esa sentencia te crea una tabla temporal table2 con la estructura de la tabla table1, y con la información de la misma. También puedes utilizar el clasico formato ...
... made. This enables copying some table[s] from one database to other database. oCn:SelectDB( "db1" )oCn:BackUp( { "table1", "table2" }, "temp.sql" )oCn:SelectDB( "db2" )oCn:Restore( "temp.sql", { ...
... MSSQL. Antonio, there are a error with ACCESS!!! Error description: Error ADODB.Recordset/6 DISP_E_UNKNOWNNAME: OPEN Args: [ 1] = C SELECT * FROM TABLE1 ORDER BY HBRECNO [ 2] = O ADODB.Connection [ 3] = N 2 [ 4] = N 3 [ 5] = N 0 Stack Calls =========== Called from: => TOLEAUTO:OPEN( 0 ) Called ...
Antonio, with Access i read this error: Error description: Error ADODB.Recordset/6 DISP_E_UNKNOWNNAME: OPEN Args: [ 1] = C SELECT * FROM TABLE1 ORDER BY HBRECNO [ 2] = O ADODB.Connection [ 3] = N 2 [ 4] = N 3 [ 5] = N 0 Stack Calls =========== Called from: => TOLEAUTO:OPEN( 0 ) Called from: ...
... DISP_E_UNKNOWNNAME: OPEN Args: [ 1] = C SELECT `AUTO_INCREMENT` FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA = 'adisc' AND TABLE_NAME = 'TABLE1' [ 2] = O ADODB.Connection Stack Calls =========== Called from: => TOLEAUTO:OPEN( 0 ) Called from: C:\adordd\adordd.prg => ADORECCOUNT( ...
In a Sql concept,you will do : oRs:Open("select ID FROM TABLE1",oCon) wid:=oRs:Fields("ID"):Value wid:=wid+1 UPDATE TABLE1 SET ID=wid * How can you lock, how are you sure that this code is not execute at the same time from another computer ...
... or ASC DESC This Set cannot include Clipper/(x)Harbour functions as they are unknown to SQL. Example: SET ADO TABLES INDEX LIST TO { {"TABLE1",{"FIRST","FIRST DESC"} }, {"TABLE2" ,{"CODID","CODID"}} } B) SET ADODBF TABLES INDEX ...
The file() function does not seem to be working. In the tryadordd.prg this function is used like this: if !FILE("table1;northwind.mdb") It always returns .F. even when the table exists. I also tried it with the preceding \ syntax (that is used elsewhere in the example program): ...
... the ADODBF are for the normal clipper expressions to allow its evaluation. ARRAY SPEC FOR BOTH CASES: ATTENTION ALL MUST BE UPPERCASE { {"TABLE1",{"FIRST","FIRST"} }, {"TABLE2" ,{"CODID","CODID"}} }
Lucas, Try it like this: //sql expressions only SET ADO TABLES INDEX LIST TO {{ "TABLE1", {"TEST1", "FIRST"} ,; {"TEST2", "LAST"} ,; {"TEST3", "AGE"} },; {"LUCAS", {"LUCAS1", ...
Antonio, It´s not working: SET ADO TABLES INDEX LIST TO {{ "TABLE1", {"TEST1", "FIRST"} ,; {"TEST2", "LAST"} ,; {"TEST3", "AGE"} },; {"LUCAS", {"LUCAS1", "NOMBRE"} ...
Antonio, Also indexes with conditions do not work, here LUCAS2: SET ADODBF TABLES INDEX LIST TO { { "TABLE1", {"TEST1", "FIRST"} ,; {"TEST2", "LAST"} ,; {"TEST3", "AGE"} },; {"LUCAS", {"LUCAS1", ...
... ADO_RELEVAL( nWA, aRelInfo ) is "allowed" In tryadordd.prg the relation should finished after the Do WHILE... MSGINFO("DOES TABLE1 EXISTS ON DB ?"+CVALTOCHAR(hb_adoRddExistsTable( "table1") )) shows .F. ???