How to create sequence reference number in my invoice but running more than one computer? 

I have some customer, asking me can i create invoice with running reference number sequenly but they have many computer will generate invoice with their clerk.

If can, could you guide me how to create that. They asking before they buy our application. This is your and my opportunities. 

I use for that an form  "INVNR" where the Invoicenumber is stored.  In this form must be only one record with the actual number.

I check this every time bevor i use the number:

        message "Check count of  Invoivenumber".
        if count of INVNR > 1 then
               message "records in Form INVNR not clear" window .
               exit .
        end

If every thing is fine i get the number and increases it for the next call

        lock File INVNR Exclusive .
           assign tInvNr := any INVNR InvNr .
           retval := SetVar("gInvNr", tInvNr) .
           modify records in INVNR InvNr := tInvNr + 1 .
        unlock File INVNR .

That works fine for me

Hallo there..... :)

I thing that using // sequenced number // with the combination of // uniqe // will do the same thing you expecting.

I use this since years in a microsolft network with no problems....

Kind regards 

Markus

Sorry for the late reply.

When you say they are running many computers are these computers linked in a network i.e. running the same application from one location or do they run many different applications in many different locations?

Download Sample!

We have just for fun created a small sample that showcase how one can have a global Sequence for local applications.

In this sample we have created a sequence service on our website that can be accessed via Remote().

We use the simplest form of Remote() -Raw mode and it just read a web page that return the number generated by a DQL stored o the server.

It can have any number of "unique" sequences as you use a key.

remote("@get: http://www.dataease.com/support/YourSequence/?fiel...

Just change myuniquekey into anything and you will have an unique sequence starting from 1.

This is obviously only scratching the surface of what you can achive with the new DataEase Server and functions like Remote().

All will be revealed later this summer with the next release of DataEase.