Thanks Walter

I am going to remove auto generated keys from all the tables in the the database for the time being.

(I thought it was the constraints I had setup . So I removed them earlier on.)

And manually generate the tran_no for the header and detail tables.

I hope that fixes the "find" header problem..

It has been frustrating ....

Walter Wrote:
What I do is use Server Request to go to my server and ask for a Unique ID.  Then I use that to store in the HeaderID and use it in the Detail to link to two tables.  No autoinc.

1. Do you have a simple example code for the "Server Request".

2. How would the the "header" and "detail" be linked  in EWB (with an edb header + detail table)?

I am familiar with the dbisam way of doing things. eg mastersource etc..

Many thanks again for your help.

Regards

Kamran

Walter Matte wrote:


The problem is here:  Auto Generated Index.  


EWB (the browser) has no knowledge of the number generated because it happened on the Server when you Commit.

I think Tim is going to add in the next release the ability to get this number back, (I think read that here in the forums).

I wrote my own server and handle these types of processes differently.  Other people have shared there AutoInc replacement to - search the forum.

What I do is use Server Request to go to my server and ask for a Unique ID.  Then I use that to store in the HeaderID and use it in the Detail to link to two tables.  No autoinc.


"But I am not using "DataBase.BaseURL"  in any way ?"  It is working since you are getting the data into EDB.


Walter

You have to design differently for the "browser".  You would never load all of your data into the browser.  You would only load what you need.


So you don't really need a MasterSource  In the Detail DataSet - just load the specific detail records for the Head you are using. And only load 1 header record into the Header Dataset.


Again I wrote my own back end server.  But you can do this with Tim's to.  Look at his examples.

The Server Request in EWB just calls the Server with a url.  In my server when I see that url - I wrote Delphi code to generate a unique id and send it back to the browser.


Walter

Thanks for all your help Walter.

I will look into this further.

Have a good day.

Kamran

Walter Matte wrote:

You have to design differently for the "browser".  You would never load all of your data into the browser.  You would only load what you need.


So you don't really need a MasterSource  In the Detail DataSet - just load the specific detail records for the Head you are using. And only load 1 header record into the Header Dataset.


Again I wrote my own back end server.  But you can do this with Tim's to.  Look at his examples.

The Server Request in EWB just calls the Server with a url.  In my server when I see that url - I wrote Delphi code to generate a unique id and send it back to the browser.


Walter