LiveCode Forums

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...

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...

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/...

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...

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 ...

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 ...

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...

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

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...

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...

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

@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...

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...

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 ...

Thanks to all for your help.

You helped me to solve my problem

Best
greg falda