Re: [sqlite] [Delphi7] TEXT vs. (VAR)CHAR?

On Wed, 05 Mar 2008 09:44:21 +0100, Marco Wobben <[EMAIL PROTECTED]> wrote: >A brief history: Thanks much for the information. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] [Delphi7] TEXT vs. (VAR)CHAR?

On Tue, 4 Mar 2008 14:33:06 -0800 (PST), Rael Bauer <[EMAIL PROTECTED]> wrote: > This type of question may better be answered on borland forums. I doubt it. Few Delphi developpers seem to work with SQLite :-/ > Maybe this will work. all events point to this published method: Thanks for the

Re: [sqlite] [Delphi7] TEXT vs. (VAR)CHAR?

On Tue, 04 Mar 2008 23:07:15 -0600, "Fred Williams" <[EMAIL PROTECTED]> wrote: >You might want to test a little further with Aducom's stuff. I'm using >Aducom and have the following working code in at least one app: > >begin > AList.Fields.FieldByName(FldName[j+1]).Value :=

Re: [sqlite] [Delphi7] TEXT vs. (VAR)CHAR?

A brief history: There used to be a size limitation in dBase and perhaps Paradox. Traditionally this was supported within the Borland Database Engine. In the Delphi components this resolved in text fields and memo fields. The Borland Database Engine (BDE) and the components within Delphi. From

Re: [sqlite] [Delphi7] TEXT vs. (VAR)CHAR?

end; Fred > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] Behalf Of Gilles Ganault > Sent: Tuesday, March 04, 2008 4:08 PM > To: sqlite-users@sqlite.org > Subject: Re: [sqlite] [Delphi7] TEXT vs. (VAR)CHAR? > > > On Tue, 4 Mar 2008 13

Re: [sqlite] [Delphi7] TEXT vs. (VAR)CHAR?

>procedure TForm1.ASQLite3Table1phones_parentGetText(Sender: TField; > var Text: String; DisplayText: Boolean); >begin > //Text := qryContacts.FieldByName('MyField').AsString; > Text := ASQLite3Table1.F >end; This property doesn't come up by code completion - but it is there. >BTW, is

Re: [sqlite] [Delphi7] TEXT vs. (VAR)CHAR?

On Tue, 4 Mar 2008 13:43:46 -0800 (PST), Rael Bauer <[EMAIL PROTECTED]> wrote: > 3. Add code in this event like the following: >Text := qryContacts.FieldByName('MyField').AsString; Thanks for the tip, but Aducom's Table component doesn't have a FieldByName property. procedure

Re: [sqlite] [Delphi7] TEXT vs. (VAR)CHAR?

Hi, First - this relates to original question. (I'm replying from yahoo, and I don't know how to reply to a specific message from a thread. Perhaps someone can tell me how to do that :) ) I think the question relates to the dataset component. Try this to see if it solves

Re: [sqlite] [Delphi7] TEXT vs. (VAR)CHAR?

Gilles Ganault wrote: > On Tue, 04 Mar 2008 14:09:51 -0500, John Elrick > <[EMAIL PROTECTED]> wrote: > >> You can't. You lose the db aware aspect, but what I'm saying is it >> isn't as "bad" as I used to think. >> > > OK, I don't mind not using DB-aware widgets if you say it's not much >

Re: [sqlite] [Delphi7] TEXT vs. (VAR)CHAR?

On Tue, 04 Mar 2008 14:09:51 -0500, John Elrick <[EMAIL PROTECTED]> wrote: >You can't. You lose the db aware aspect, but what I'm saying is it >isn't as "bad" as I used to think. OK, I don't mind not using DB-aware widgets if you say it's not much more work. So how do you 1) access an SQLite

Re: [sqlite] [Delphi7] TEXT vs. (VAR)CHAR?

Gilles Ganault wrote: > >> We haven't used TDataSource in quite some time and actually don't miss it. >> > > I didn't know you could do away with all those components to connect > DB-aware widgets. If you have some DelphiWin32 "hello, world" sort of > code, I'm very interested :-) > You

Re: [sqlite] [Delphi7] TEXT vs. (VAR)CHAR?

On Tue, 4 Mar 2008 11:39:40 -0600, "P Kishor" <[EMAIL PROTECTED]> wrote: >I think you really need to read I did. The problem is not SQLite, it's the connector (Delphi, in this case). If I knew how and I could still use DB-aware grids, I would gladly get rid

Re: [sqlite] [Delphi7] TEXT vs. (VAR)CHAR?

On Tue, 04 Mar 2008 12:43:30 -0500, John Elrick <[EMAIL PROTECTED]> wrote: >The component. We used Aducom for a while and found that TEXT is >internally converted to a TMemo field. If you examine the source, you >can see the conversions. OK, so Aducom is out. I'll give DISQLite a deeper look,

Re: [sqlite] [Delphi7] TEXT vs. (VAR)CHAR?

Gilles Ganault wrote: > On Tue, 04 Mar 2008 09:27:14 -0500, John Elrick > <[EMAIL PROTECTED]> wrote: > >> FYI, we rolled our own adapters for a Delphi project. We had no use for >> the TDataset capabilities and removed the overhead. I would be happy to >> share them if they would help. >>

Re: [sqlite] [Delphi7] TEXT vs. (VAR)CHAR?

On 3/4/08, Gilles Ganault <[EMAIL PROTECTED]> wrote: > On Tue, 4 Mar 2008 11:03:44 -0600, "P Kishor" > <[EMAIL PROTECTED]> wrote: > >I think that was the point of my saying, "Anything using SQLite is > >free to do what it wants." I routinely write Perl code that checks > >what I am inserting

Re: [sqlite] [Delphi7] TEXT vs. (VAR)CHAR?

On Tue, 4 Mar 2008 11:03:44 -0600, "P Kishor" <[EMAIL PROTECTED]> wrote: >I think that was the point of my saying, "Anything using SQLite is >free to do what it wants." I routinely write Perl code that checks >what I am inserting into SQLite and croaks if something is not as I >expected. So, even

Re: [sqlite] [Delphi7] TEXT vs. (VAR)CHAR?

On Tue, 04 Mar 2008 09:27:14 -0500, John Elrick <[EMAIL PROTECTED]> wrote: >FYI, we rolled our own adapters for a Delphi project. We had no use for >the TDataset capabilities and removed the overhead. I would be happy to >share them if they would help. I haven't found a good guide/tutorial on

Re: [sqlite] [Delphi7] TEXT vs. (VAR)CHAR?

On 3/4/08, John Elrick <[EMAIL PROTECTED]> wrote: > P Kishor wrote: > > I think you have answered you question yourself. See below -- > > > > On 3/4/08, Gilles Ganault <[EMAIL PROTECTED]> wrote: > > > >> Hello > >> > >> I thought that SQLite treated any numeric data the same, but

Re: [sqlite] [Delphi7] TEXT vs. (VAR)CHAR?

P Kishor wrote: > I think you have answered you question yourself. See below -- > > On 3/4/08, Gilles Ganault <[EMAIL PROTECTED]> wrote: > >> Hello >> >> I thought that SQLite treated any numeric data the same, but some >> Delphi components seem to handle TEXT data as BLOB/MEMO, and

Re: [sqlite] [Delphi7] TEXT vs. (VAR)CHAR?

I think you have answered you question yourself. See below -- On 3/4/08, Gilles Ganault <[EMAIL PROTECTED]> wrote: > Hello > > I thought that SQLite treated any numeric data the same, but some > Delphi components seem to handle TEXT data as BLOB/MEMO, and handle > VARCHAR as regular

Re: [sqlite] [Delphi7] TEXT vs. (VAR)CHAR?

Gilles Ganault wrote: > On Tue, 4 Mar 2008 09:00:31 -0500, "Igor Tandetnik" > <[EMAIL PROTECTED]> wrote: > >> There's no difference as far as SQLite is concerned. Length >> specification, if present, is parsed but not enforced. >> > > Yes, that's what I read too, but obviously, like

Re: [sqlite] [Delphi7] TEXT vs. (VAR)CHAR?

On Tue, 4 Mar 2008 09:00:31 -0500, "Igor Tandetnik" <[EMAIL PROTECTED]> wrote: >There's no difference as far as SQLite is concerned. Length >specification, if present, is parsed but not enforced. Yes, that's what I read too, but obviously, like Apple, some component in Delphi think different :-)

Re: [sqlite] [Delphi7] TEXT vs. (VAR)CHAR?

"Gilles Ganault" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > I'd like to know if there are drawbacks to switching from TEXT to > (VAR)CHAR? There's no difference as far as SQLite is concerned. Length specification, if present, is parsed but not enforced. For more details, see