Why do you have spaces in your parameter names anyway ??
the parameter names do not have to bear any resemblance to the name of the
field they are parameters for, you could use :f1,:f2,:f3 if you wanted. And
if you are inserting a value to every field, you can drop the field names
completely (as long as the parameters are in the same order as the fields in
the table.
Sammy !
----- Original Message -----
From: "Derricutt, Mark" <[EMAIL PROTECTED]>
To: "Multiple recipients of list database" <[EMAIL PROTECTED]>
Sent: Tuesday, August 08, 2000 4:45 PM
Subject: [DUG-DB]: spaces in fields :(
> 'lo, once again I have to deal with spaces in field names, for the
following
> query, what do I use (against paradox):
>
> INSERT INTO welpres
> ( Well, Well Test Type, Test Start Date, Test Start Time / ID,
> Measurement Date, Measurement Time, Depth, Brine Flow, Enthalpy,
> FType, Mass Flow, Separation Pressure, Steam Flow, Well Pressure, Well
> Temperature, WHP, Notes)
> VALUES
> ( :Well, :Well Test Type, :Test Start Date, :Test Start Time / ID,
> :Measurement Date, :Measurement Time, :Depth, :Brine Flow, :Enthalpy,
> :FType, :Mass Flow, :Separation Pressure, :Steam Flow, :Well Pressure,
> :Well Temperature, :WHP, :Notes)
>
> It's for an update query, can I put the parameters in "'s. the last I
tried
> this I got strange problems.... oh for a database without spaces in
> fields...
>
>
> --
> Inspired by the taste of horror, proud to be insane forever
> Let out the killer in me! (c) Dismal Euphony
> Now Playing: Various Artists - Sign Of The Southern Cross - Fates Warning
> --------------------------------------------------------------------------
-
> New Zealand Delphi Users group - Database List - [EMAIL PROTECTED]
> Website: http://www.delphi.org.nz
>
---------------------------------------------------------------------------
New Zealand Delphi Users group - Database List - [EMAIL PROTECTED]
Website: http://www.delphi.org.nz
