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

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

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

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

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

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