1. PDox->Delphi; Three Questions HELP!
Not sure of the degree to which the use of Paradox/Database Desktop (DBD)
QBE files were tested for use in Delphi (if at all), but my experience has
been that:
1. Yes, you can use them in this manner.
2. The result set will always be read-only.
Some QBE files that use odd combinations or conditions may not work, some
"playing around" would be adviseable.
Default values work, but the Picture templates do not. Minimum and Maximum
constraints (validity checks) do work, but will not fire until an attempt
is made to post a record with changes. Referential Integrity works.
No. Automatically incrementing fields -- whether the Paradox Auto-increment
or the LIBS trigger-based incrementing -- are a function of the data engine
back-end. This operation is totally outside the awareness and control of
the front-end application.
In Delphi, when you "insert" a record, the table file is not affected.
Delphi merely (speaking in general terms, here) allocates memory and
displays blank entry points/cells on screen. When an attempt to post is
made, a signal goes from the application front-end to the data back-end to
add a record to the file (more like the SQL command INSERT). It is when the
data back-end receives this signal that the incrementation fires.
So if you were to consistently use a fast sequence that does a Delphi
"insert", posts the new record (causing an incrementing), and then
immediately puts the record back into editable mode. This would look
something like:
with Table1 do begin
Insert;
Post;
Edit;
end;
**************************************************************************
Steve Koterski "Results! Why, man, I have gotten a lot of
Product Group Manager results. I know several thousand things
Delphi Technical Support that won't work."
Borland International, Inc. -- Thomas Edison, 1847-1931
2. MSDE Licencing for SQL server 2000
3. Delphi>>>>>>>
4. wanted in Seattle: adminstrator for SQL Server / Site Server / Transaction Server
5. IIS->ISAPI->Delphi DLL->BDE->Paradox
6. DTS designer error
7. HELP>>HELP>>Using an Index for an MSSQL database
8. PdoxWin 5.0 bug list. where?
9. Delphi Form in PDox questions
10. Delphi Form in PDox Questions
11. PDOX DOS .SC -> PDOX 4.5 WINDOWS
12. Help? Password PDox files and Delphi ReadOnly property