Please help...
-
The following proc should find the record(contract)in db based on type(takes the position in the file and compare to the Type in the db).Proc. should return contract for use in different proc. Please help...I can't understand why it's not working. dbproc_get1 ->connection to SQL int find_record() {dbcmd (dbproc_get1, "select contract from type"); dbfcmd(dbproc_get1,"where type = %d",Type); // Send the command to SQL Server and start execution. dbsqlexec (dbproc_get1); // Process the results. if (dbresults (dbproc_get1) == SUCCEED) {dbbind (dbproc_get1, 1, INTBIND, 0, (BYTE *) &contract); while (dbnextrow (dbproc_get1) != NO_MORE_ROWS) return(1); }:confused:
-
The following proc should find the record(contract)in db based on type(takes the position in the file and compare to the Type in the db).Proc. should return contract for use in different proc. Please help...I can't understand why it's not working. dbproc_get1 ->connection to SQL int find_record() {dbcmd (dbproc_get1, "select contract from type"); dbfcmd(dbproc_get1,"where type = %d",Type); // Send the command to SQL Server and start execution. dbsqlexec (dbproc_get1); // Process the results. if (dbresults (dbproc_get1) == SUCCEED) {dbbind (dbproc_get1, 1, INTBIND, 0, (BYTE *) &contract); while (dbnextrow (dbproc_get1) != NO_MORE_ROWS) return(1); }:confused: