Re: How to convert NULL value to a empty string?
From: Brian Bushay TeamB (BBushay_at_Nmpls.com)
Date: 01/21/04
- Next message: Andrew: "Re: ADO Connection Failure"
- Previous message: Brian Bushay TeamB: "Re: Login form is not responsive when connecting to the DB"
- In reply to: nieurig: "How to convert NULL value to a empty string?"
- Next in thread: nieurig: "Re: How to convert NULL value to a empty string?"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Date: Tue, 20 Jan 2004 20:42:05 -0600
>Hello forum,
>i like to excecute the following "insert into" statement to a Access
>Database via ADO.
>
> tmpSQL := 'INSERT INTO Tab1 ( PosSorteID, AuftragID, Storage ) '+
> 'SELECT ID, AuftragID, '+
>==> 'Field1+" "+Code'+
> 'FROM Tab2 WHERE ID = '+varID;
> CommandText := tmpSQL;
> Execute;
>
>Because the Field "Code" sometimes has no data (IS NULL)
>i get no result value for the field "storage" at some records.
If code is a Tfield use the AsString method
AdoDataset1.fieldbyName('code').asString
-- Brian Bushay (TeamB) Bbushay@NMPLS.com
- Next message: Andrew: "Re: ADO Connection Failure"
- Previous message: Brian Bushay TeamB: "Re: Login form is not responsive when connecting to the DB"
- In reply to: nieurig: "How to convert NULL value to a empty string?"
- Next in thread: nieurig: "Re: How to convert NULL value to a empty string?"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Relevant Pages
|
