Search found 5 matches

by anjemalo
Fri Oct 14, 2016 9:52 am
Forum: Getting Started with LiveCode - Complete Beginners
Topic: Get data from a field in SQlite
Replies: 11
Views: 4679

Re: Get data from a field in SQlite

Many thanks to all of you.
Best regards
by anjemalo
Thu Oct 13, 2016 9:22 pm
Forum: Getting Started with LiveCode - Complete Beginners
Topic: Get data from a field in SQlite
Replies: 11
Views: 4679

Re: Get data from a field in SQlite

Is there a way to get only the data from a field named "telephone" of a specific record?

Using the above code I get data not desirable. for example:

958123456
2
these are two records, because the first does not have TAB.
by anjemalo
Thu Oct 13, 2016 9:17 pm
Forum: Getting Started with LiveCode - Complete Beginners
Topic: Get data from a field in SQlite
Replies: 11
Views: 4679

Re: Get data from a field in SQlite

That't working. thank you.

How then, I can disable itemdelimiter after get the data fields?

I need to get data from fields of individual records. For example record number four.
by anjemalo
Thu Oct 13, 2016 8:31 pm
Forum: Getting Started with LiveCode - Complete Beginners
Topic: Get data from a field in SQlite
Replies: 11
Views: 4679

Re: Get data from a field in SQlite

thank you for your response. I worked with SQL in other programming languages. I am new with Livecode. I need to get the data from a field name for example "telephone" This is my code: on mouseUp -- check the global connection ID to make sure we have a database connection global gConnectionID if gCo...
by anjemalo
Thu Oct 13, 2016 7:52 pm
Forum: Getting Started with LiveCode - Complete Beginners
Topic: Get data from a field in SQlite
Replies: 11
Views: 4679

Get data from a field in SQlite

Hello:

I have created an SQLite dabatase an I have three fields on it, named:

ID , name and telephone

I want to get the data from a field of one record.
When I write:

put fld "telephone"

I get all records and not the phone number

Can you help me please?