Search found 18 matches
- Thu Jun 08, 2017 2:05 pm
- Forum: Talking LiveCode
- Topic: Is there a limitation for the size of a string?
- Replies: 3
- Views: 2832
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...
- Wed Jun 07, 2017 11:43 am
- Forum: Talking LiveCode
- Topic: Where is the list of all libraries?
- Replies: 2
- Views: 2556
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...
- 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: 2387
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/...
- Wed May 24, 2017 11:21 am
- Forum: Talking LiveCode
- Topic: How to create data sync: LiveCode app <-> server with MySQL?
- Replies: 1
- Views: 2410
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...
- 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: 3876
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 ...
- 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: 3876
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 ...
- 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: 3876
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...
- 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: 4051
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
Drag and drop of controls in project browser is buggy in my case - LiveCode 8.1.2
best,
greg falda
Thanks for the help. I finally reordered the controls via code using commands like
Code: Select all
set the layer of ...
best,
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: 4051
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...
- 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: 4051
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...
- 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: 7122
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
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
- 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: 7122
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...
- 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: 7122
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...
- Thu Sep 15, 2016 11:31 am
- Forum: Talking LiveCode
- Topic: Testing the brand new LiveCode 8.1 - a report
- Replies: 0
- Views: 1449
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 ...
- 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: 3993
Re: Storing date to a database, retrieving it and displaying
Thanks to all for your help.
You helped me to solve my problem
Best
greg falda
You helped me to solve my problem
Best
greg falda