Search results for query: *

hi everyone, i'm trying to increment a previous value in a table and then insert in the same column when the query is executed. for example: number description 6001 blah blah blah 6002 ..... <---last and largest existing value in table <END OF TABLE>...

hi everyone, i was wondering if anyone knew the syntax for creating a query that will do multiple inserts. for example: in tabel UserService i want to insert the value &quot;None&quot; in the Service field of the table where the GroupIDs in the table equals 1, 2, 3, 4, and 5. if anyone has...

hello everyone, i was wondering if anyone knew if it is possible to automate queries in MS Access to run daily and create a report? thanks in advance, angel

hello everyone, i was wondering if anyone knew what the reserved word is to get today's date in a SQL statement... i'm trying to write a query that will subtract the current date from yesterday's date without having to manually insert and change the dates. i thought i could use 'date$' but it...

Hello, What I'm trying to do it calculate the number of keys available (KEYS_AVAIL) after subtracting the NEXT_VALUE, in the CTRL_KEY_VALUE table, from MAX_KEY_VALUE, in the OFFICE_CODES table, to find out how many keys are left and to return the value in the KEYS_AVAIL field in the OFFICE_CODES...

Hello everyone, I'm trying to create a couple of SQL query that I need some help with... I'm trying to create a SQL query that will do mass inserts into a table. I'm using a select statement with an embedded insert statement, but I realized that the insert statements allow one insert at a time...

In COBOL, what does the error message FILE STATUS = 39 mean? And, what is a common way to go about fixing it?

What does the reserved IBM COBOL 85 word mean: RECORDING MODE IS F????