Search results for query: *

Pervasive 13.31 The SQL statement works in access with the PSQL tables linked. I've run it in the PCC SQL editor, see attached image, from that image you can see the tables exist and I'm logged into that database. Thanks for any help, i'm very new to this! Edit: This might work. I'm just...

This is in C:\PSQL Scripts\ResetAuditDates.sql: UPDATE INVENTORY_MST2 INNER JOIN INVENTORY_MSTR ON INVENTORY_MST2.PART = INVENTORY_MSTR.PART SET INVENTORY_MST2.DATE_CYCLE = '000000' WHERE ((Not (INVENTORY_MSTR.CODE_ABC)='A' And Not (INVENTORY_MSTR.CODE_ABC)='B')) I'm specifying the table after...

Thanks for your response mirtheil, really big help! This is what I'm trying: C:\PSQL\bin\pvddl.exe GLOBALSEL "C:\PSQL Scripts\ResetAuditDates.sql" -username xxx -password xxx -log "C:\PSQL Scripts\log.txt GLOBALSEL is the serverDSN (see attached image) I still get: pvddl: A table or view name...

Thanks mirtheil That will work perfectly! I will need to specify which database to run the script on? we have a number of database's, apologises I'm very new to PSQL and only really have experience with MS access -_- With access I just connect to the relevant database and then run my script/s...

I need to run an update query periodically. It basically set's audit dates to 000000. these dates are set as and when people up date stock records or when someone runs the 'update cycle count dates'. So I need it to run at night, ready for the morning's counts. UPDATE INVENTORY_MST2 INNER...