LiveCode Forums.

Thank you
I will read about the post command. If any one has any pointers were to start it will be very much apreciated
thank you again
John

Thank you
lets say I like to have all queries on the server side. How can I possible pass the criteria row from LC field to the SQL querie on the server side
for ex:

Thank you for the Lessons I get the idea. I have several questions?
1 will any of the recommendation impact the sql query execution performance +/=
2 is it good idea or not to call queries that reside on the server side?
thank you again
John

Hi Klaus
Got it. Can you let me know what && and \ indicate to LC
Thank you for the help.

Funny I had a long night
" deal with long statesmen"
thank you again for all the help
John

is any way that I format a long query like this one "Select Inventory.PLU_Number,Inventory.Plu_Description,Brands. Brand_Name,Department_Name,Inventory_Prices.Price From Inventory Inner Join Brands On Inventory.Brand_Number = Brands.Brand_Number Inner Join Departments On Inventory.Department_Number ...

can some one point me to the right direction Need to use single quotes ' ' in the query bellow in order for my query to work in the MsSQL server as the column is VCHAR and have to include the ' ' like this "SELECT * FROM Inventory_Prices WHERE PLU_Number = " 111111111 ' global gConID on mouseUp put"...

Good luck with the moving no problem and thank you for the help I appreciated what I like to understand and learn is, when i select a line from the grid PO ORDERS to pass the PO NUMBER to this SQL statement, but I have to be able to change the put "SELECT * FROM PO_Detail WHERE PO_Number =1" into tQ...

I have read all the need it and understand the concept a bit better I have manage to do this however I do not get any errors and no results as well other than theDataA in to DataGrid 2 where I have gone wrong any help is much apreciated Thank you on mouseUp pMouseBtnNum if pMouseBtnNum is 1 then put...

Thank you Simon I can place the SQl queries into the grid, how ever how I can run the query below when I select a line in grid 1 via the checkbox and in the Where statement will change to the number of the selected row based of the field dbo.PO_Master.PO_Number Select StoreTenderOnline.dbo.PO_Master...

Yes, that is not a problem

http://s29.postimg.org/psepnro3b/orders.jpg Thank you I like to learn how to tell LC when I check line one with Id (1) to pass the order detail in the second grid Here is the SQL Query Select StoreTenderOnline.dbo.PO_Master.PO_Number, StoreTenderOnline.dbo.PO_Detail.PO_Number As PO_Number1, StoreTe...

Thank you
I do not have and issue with the SQL query. I try do understand how to tell LC when I select a row with Vendor ID "1" to show all data with Vendor ID"1" from table Products do you know of any examples for me to see
thank you
John

Can some one please let me know or point me to an example to do this
I have two tables Vendors, and the other products. Also I like to have two grids, That when I select a Vendor in one I will see all the Products for the selected Vendor
Thank you

thank you for the help
May I ask you if that is the proper and most efficient way to do this, is any other way as well
Thank you again

I have this code on MouseUp global gConID put field "FName" into tFName put "INSERT INTO apps (appName) " into tSQL put "VALUES (" & tFName & ");" after tSQL revExecuteSQL gConID, tSQL if the result is not 1 then answer warning the result exit to top end if end mouseUp that suppose to get the values...