fisace
asked on
Paradox table not refreshing
I have a Delphi 5 application accessing a paradox dataabase. The database is on a server. I want to get the next invoice number from a table and then incrament it number by one. The application works fine on a single machine but when I try to access the the next number from a different machine the paradox table has not been updates. It is only updatede when the application is turned off. I am using the following sql
insert into invoiceno
(InvoiceNo)
values
(:InvoiceNo)
select max(InvoiceNo) as newNumber from InvoiceNo
Is there a reason why the table does not update across the network. I have cached updates set to false
Thanks
insert into invoiceno
(InvoiceNo)
values
(:InvoiceNo)
select max(InvoiceNo) as newNumber from InvoiceNo
Is there a reason why the table does not update across the network. I have cached updates set to false
Thanks
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.