ACUSERVER
When performing several select on the
same table name by the same userid
Why when we execute ./acuserve -i in unix
do we see more than one entry for the combination
user-id-table name
CLIENT USER PID TY FID FILE NAME
cmi26752 danifort 170 I 4332d4 /prog/tdllink/ivprod
cmi26752 danifort 170 I 4332d4 /prog/tdllink/ivprod
VBA CODE:
Set DB_TDL = OpenDatabase("TDL Mangest SAD", dbDriverNoPrompt, True, "ODBC;
DRIVER=AcuODBC ;DSN=TDL Mangest SAD")
Set RS_TDL_IVPROD = Nothing
Set RS_TDL_IVPROD = DB_TDL.OpenRecordset("Ivprod", dbOpenDynaset)
Set RS_TDL_IVPROD = DB_TDL.OpenRecordset("Select Ivprod_Line_code from
ivprod where ivprod_line_code = 'T3K' and ivprod_item_code = '00001'",
dbOpenDynaset, dbReadOnly)
RS_TDL_IVPROD.Close
DB_TDL.Close
