I have created a small 4 column d-base and if I do a "select * from table"
sqlite always returns to me the order of the data in the order that it was
listed in the create statement. (Actually, I based a lot of functionality in a
small C++ program I wrote on this, and it has never failed. I've
Thanks for everyones help, I'm actually building the
query dynamically based on what the user inputs, must
be my string handling functionality in Borland that
causing probs Thanks again.
--- Jay Sprenkle <[EMAIL PROTECTED]> wrote:
> > Put mulitple record into your table and see what
> > occu
Put mulitple record into your table and see what
occurs.
--- Puneet Kishor <[EMAIL PROTECTED]> wrote:
> Nicholas Choate wrote:
> > Tried that, same result. Any other ideas?
>
> here is what I get
>
> D:\user\punkish>sqlite3 test.db
> SQLite
Tried that, same result. Any other ideas?
Newly revised code:
Update sys_list set pass = 'abcdf;456' where
sys_id = 'testboxa' and user_id = 'testuserid';
--- Puneet Kishor <[EMAIL PROTECTED]> wrote:
>
> On Jul 18, 2005, at 10:57 AM, Nicholas Ch
I'll try that, thanks for the suggestion.
Puneet Kishor <[EMAIL PROTECTED]> wrote:
On Jul 18, 2005, at 10:57 AM, Nicholas Choate wrote:
> Sorry forgot the SQL on the previous email.
>
> Update sys_list set pass = "abcdf;456" where sys_id = "testboxa&quo
ROTECTED]> wrote:
You should post your sql
On 7/18/05, Nicholas Choate wrote:
> I have noticed a quirk with the Update command and was just wondering if
> there was a way to fix it. I am attempting to update two fields in my
> database and I've noticed that if there is a
Jay Sprenkle <[EMAIL PROTECTED]> wrote:You should post your sql
On 7/18/05, Nicholas Choate wrote:
> I have noticed a quirk with the Update command and was just wondering if
> there was a way to fix it. I am attempting to update two fields in my
> database and I've notice
I have noticed a quirk with the Update command and was just wondering if there
was a way to fix it. I am attempting to update two fields in my database and
I've noticed that if there is a ";" in the text field for one of the fields I'm
updating, it updates every record with the same information
8 matches
Mail list logo
