|
|||||||||
|
|||||||||
| |||||||||
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
Dev Shed Forums Sponsor:
|
|
|
|
#1
November 5th, 2006, 05:05 AM
|
|||
|
|||
|
Creating table and filling it in one transaction
Hello. I'm developing an application in Delphi + Firebird. I want to create some tables and fill them with data. But everything must be in one transaction so when something goes wrong I can rollback transaction. But I can't achive that. When I create a table for example Company, and then I try to fill it up with data I get error message
Dynamic SQL Error SQL error code = -204 Table unknown Company Is it possible to create tables and fill them with data in one transaction ?
|
|
#2
November 6th, 2006, 02:22 AM
|
||||
|
||||
|
Did you try from the command line?
__________________
My blog Tutorials about OSS databases, DBMonster ... Contribute to OSS Development, fill bug reports! Developer Shed eSupport Commented my.ini/my.cnf (ADD YOUR OWN CONFIG TRICK) An introduction to database normalization Natural or Surrogate key Custom ordering for your results Correlated and uncorrelated subqueries Don't turn your outer joins into inner joins Random data (with a bias)
|
|
| Viewing: Dev Shed Forums > Databases > Firebird SQL Development > Creating table and filling it in one transaction |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
