Search found 18 matches

by greg falda
Thu Jun 08, 2017 2:05 pm
Forum: Talking LiveCode
Topic: Is there a limitation for the size of a string?
Replies: 3
Views: 829

Is there a limitation for the size of a string?

Dear All I'm planning to pass queries to SQL databases, where the queries can be potentially really long, like INSERT INTO ... VALUES ...; where the VALUES may contain multiple rows of multiple records. Hence my question: Is there a limitation for the size (length) of a string in LiveCode? Thanks in...
by greg falda
Wed Jun 07, 2017 11:43 am
Forum: Talking LiveCode
Topic: Where is the list of all libraries?
Replies: 2
Views: 840

Where is the list of all libraries?

Dear All LiveCode has a set of libraries originating from Revolution - names of commands start with rev... In the dictionary, I can find for instance the following commands, with associated libraries (see: associations) : revQueryDatabase – database library revStopAnimation - animation library revSt...
by greg falda
Wed Jun 07, 2017 11:23 am
Forum: Talking LiveCode
Topic: How to call a stored procedure in an external MySQL DB?
Replies: 1
Views: 946

How to call a stored procedure in an external MySQL DB?

Dear All Assume that I have connected from LiveCode to an external MySQL database using code like: -- connect to the database put revOpenDatabase("MySQL", tDatabaseAddress, tDatabaseName, tDatabaseUser, tDatabasePassword) into tResult as described in the lesson: http://lessons.livecode.com/m/4071/l/...
by greg falda
Wed May 24, 2017 11:21 am
Forum: Talking LiveCode
Topic: How to create data sync: LiveCode app <-> server with MySQL?
Replies: 1
Views: 883

How to create data sync: LiveCode app <-> server with MySQL?

Dear all I have a mobile SQLite database of my LiveCode app (Android, iOS). On the LiveCode server, I have a MySQL database. Both databases have (logically) the same tables with the same data. The data may be updated in any of the databases. On the mobile - by my LiveCode app, on the server - by a W...
by greg falda
Tue May 23, 2017 12:36 pm
Forum: Talking LiveCode
Topic: How to get data from a record pointed by a cursor?
Replies: 4
Views: 1200

Re: How to get data from a record pointed by a cursor?

Dear AxWald Yes! You're right: I needed revDatabaseColumnNamed(tCursor,"fieldname") By currently, no good experience. When I loop with the cursor, then - within the loop - the test code answer "revDatabaseColumnNamed(tCursor,'fieldname') = " & revDatabaseColumnNamed(tCursor,"fieldname") simply does ...
by greg falda
Mon May 22, 2017 11:04 am
Forum: Talking LiveCode
Topic: How to get data from a record pointed by a cursor?
Replies: 4
Views: 1200

Re: How to get data from a record pointed by a cursor?

Dear richmond62 Thank you for your response. Now I see that I should clarify my request. 1) First of all: My problem is not connected with any data grids. In fact it is not connected with any UI. My code should explicitely create the cursor. In fact, I have already created the corresponing function ...
by greg falda
Sun May 21, 2017 2:02 pm
Forum: Talking LiveCode
Topic: How to get data from a record pointed by a cursor?
Replies: 4
Views: 1200

How to get data from a record pointed by a cursor?

Assume I have a database cursor and I succesfully move to a next record issuing revMoveToNextRecord theCursor i.e. the cursor points now to a record. Assume that the record has the value "John" in the column called first_name. I simply want to get this value using the cursor. I want to put the value...
by greg falda
Sun Feb 19, 2017 4:11 pm
Forum: Getting Started with LiveCode - Experienced Developers
Topic: Setting proper values to layer of a control in a group
Replies: 4
Views: 1613

Re: Setting proper values to layer of a control in a group

Dear all

Thanks for the help. I finally reordered the controls via code using commands like

Code: Select all

set the layer of ...
Drag and drop of controls in project browser is buggy in my case - LiveCode 8.1.2

best,
greg falda
by greg falda
Fri Feb 10, 2017 9:05 am
Forum: Getting Started with LiveCode - Experienced Developers
Topic: Setting proper values to layer of a control in a group
Replies: 4
Views: 1613

Re: Setting proper values to layer of a control in a group

Dear Craig Yes, this is a data grid with a scrolling list. The group represents each row in the list, but is defined as "form", so I can place controls freely in the row (the other option, which I do not use is called "grid" - as far as I remember - and leads to a grid like in a spreadhseet) I'll tr...
by greg falda
Thu Feb 09, 2017 12:41 pm
Forum: Getting Started with LiveCode - Experienced Developers
Topic: Setting proper values to layer of a control in a group
Replies: 4
Views: 1613

Setting proper values to layer of a control in a group

Could you tell me how to set a requested value to the layer of a control in a group and especially in the row template? When I set the layer in the inspector (bottom of tab: position), the layer resets to some other value and hance I cannot control which controls are on the front and which are hidde...
by greg falda
Tue Dec 06, 2016 1:03 pm
Forum: Getting Started with LiveCode - Experienced Developers
Topic: Dealing with zero date (null value) to represent:no date set
Replies: 14
Views: 1938

Re: Dealing with zero date (null value) to represent:no date

Dear all

Thank you for your valuable help. I finally managed it by keeping (in the same db field) the date (if date has been set by user) or the string "no date set" (if user decided that no date should be set in this place). Now it works.

Best,
greg falda
by greg falda
Mon Nov 21, 2016 5:00 pm
Forum: Getting Started with LiveCode - Experienced Developers
Topic: Dealing with zero date (null value) to represent:no date set
Replies: 14
Views: 1938

Re: Dealing with zero date (null value) to represent:no date

@FourthWorld and all : @Greg: It may be helpful to understand more about the context of your code. To start with, is tDate coming from a user-entered value? If so, where does the user enter that value? If not, where does it come from? OK. Thank you for your question. The overall goal is simple : I w...
by greg falda
Wed Nov 16, 2016 3:30 pm
Forum: Getting Started with LiveCode - Experienced Developers
Topic: Dealing with zero date (null value) to represent:no date set
Replies: 14
Views: 1938

Dealing with zero date (null value) to represent:no date set

Hello! Please look at my question. Sadly, no one answered me before :-( I try now to clarify my question - in short: How to set and check a null-value for date? (which I internally use for "no date value set here") What I call zero date is Jan 1 st 1970 (this is in fact the earliest date to be set i...
by greg falda
Thu Sep 15, 2016 11:31 am
Forum: Talking LiveCode
Topic: Testing the brand new LiveCode 8.1 - a report
Replies: 0
Views: 522

Testing the brand new LiveCode 8.1 - a report

Hello I used 7.1.4 so far and yesterday I tried the brand new 8.1 (I never used 8.0) . My impressions – especially UI. Some nasty issues from 7 are now gone :-) esp.: 1) Many windows opened very low on the screen with only a narrow stripe visible on the bottom of the screen 2) After some time, some ...
by greg falda
Wed Mar 02, 2016 8:00 pm
Forum: Getting Started with LiveCode - Experienced Developers
Topic: Storing date to a database, retrieving it and displaying it
Replies: 5
Views: 1178

Re: Storing date to a database, retrieving it and displaying

Thanks to all for your help.

You helped me to solve my problem :D

Best
greg falda

Go to advanced search