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

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 := Trim(ExtractData(RS)); if RP >= Length(RS) then break; end;

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] PRAGMA auto_vacuum

Raviv Shasha wrote: > > Can I run the PRAGMA command without using sqlite3_exec command? > Well, yes you could use the prepared statement APIs, but generally sqlite3_exec() is somewhat easier for statemnts you don't need to repeat (like and insert). > According to the sqlite documentation

Re: [sqlite] installing DBD::SQLite::Amalgamation and sqlite3 v3.5.6

Greetings, First, kindly send emails to the group (although cc-ing me is fine) as there are others way more competent than me you can answer your questions. More importantly, other lurkers might learn from your experience, and we don't want to lose that, do we. On 3/4/08, rahed <[EMAIL

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] Can I automatically create a 'disambiguation' number in a second field of a primary key?

-Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Dennis Cote Sent: Monday, March 03, 2008 6:38 PM To: General Discussion of SQLite Database Subject: Re: [sqlite] Can I automatically create a 'disambiguation' number in a second field of a primary key? Paul

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

Re: [sqlite] [newbie] SQLite and VB.Net?

On Mon, 3 Mar 2008 11:48:00 -0500, "Samuel Neff" <[EMAIL PROTECTED]> wrote: >The performance impact of using ADO.NET vs direct is miniscule and greatly >outweighed by the improved efficiency in development. Good news. Thanks much for the input. ___

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

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 text: http://img404.imageshack.us/img404/8614/nextdbgridparentzt9.jpg

[sqlite] Database on shared (afp) Mac OS X volume?

Greetings, I checked the list and did the usual google search for the answer to this question but turned up nothing. I'm compiling 3.5.6 on the Mac (10.4.11) and want to be able to use the database on a shared volume. I found information to the the effect of having to define

[sqlite] Queries within loadable extensions

Hi All, I have been playing around with loadable extensions and am calling some C code to do batch processing from database triggers like so: SQL: CREATE TRIGGER mytrigger AFTER UPDATE OF myfield ON mytable BEGIN [do some stuff] INSERT INTO batch_table (id) SELECT ... [ids of rows

Re: [sqlite] newB question; c++ and sqlite3; how2 check if word exist in the table

dear Dennis thank u 4 reply once more, i'll try with your suggestion vl Dennis Cote wrote: > > vl.pavlov wrote: >> >> i wander how 2 check (efficiently) if some word (string, in c++) exist in >> the sqlite3 table >> > > Assuming this is the same database as your last question. You have

Re: [sqlite] Two different DLLs linked statically to Sqlite and loaded in the same process

From what I remember, an attempt at database compatibility is attempted across major revision numbers (i.e. all SQLite v2 revisions can read SQLite v2 databases, all SQLite v3 revisions can read SQLite v3 databases), but I can't remember. I don't believe it's generally recommended to be

Re: [sqlite] Compiling sources for Coldfire embedded platform

Actually, the correct way would be to do make CC=compilername, although for most situations it may produce the same effect. Also, SQLite uses autotools, so it's just a matter of doing CC=compilername ./configure. You can find more info using ./configure --help. Also, for cross-compilation,

Re: [sqlite] installation of sqlite in linux

debz wrote: > I have downloaded tclsqlite-3.5.6.so.gz(with tcl binding , i need tcl).I dont > know how to install.plz help. > > You should be able to either put it into a common system library path (i.e. /usr/lib) or set the environment variable LD_LIBRARY_PATH before invoking the program

Re: [sqlite] PRAGMA auto_vacuum

Hi, Thanks for your question. Can I run the PRAGMA command without using sqlite3_exec command? According to the sqlite documentation the PRAGMA vacuum commands are the following : For query -> PRAGMA auto_vacuum; For Set -> PRAGMA auto_vacuum = 0 | none | 1 | full | 2 | incremental; While