Reputation: 0 Apprentice
- New Members
- Active Posts:
- 2 (0 per day)
- 11-May 12
- Profile Views:
- Last Active:
- May 17 2012 04:34 AM
- Dream Kudos:
Posts I've Made
Posted 11 May 2012Hmm I was sure I saw them before, but maybe I just saw the autocomplete in Google. Have to tried emailing their support? Does the application come with help files? They would be the places to start.
i emailed support and i read all the help files. none of them say anything about linking a db grid with a seperate form. This is the only problem im having. I got sql to do uses setup. i can go into my applicaton and add a new user and i can access it with that user code. I know it has to eather be a sql or actions. Im thinking maybe sql like Select * from Blah blah Where Id and idk what to put after that. Id is my primary Key.
There is no simple way to do this. maybe in the next vertion.
I suggest that you define a global variable (example IDVAR) then read the user field into this variable
Dbtable1.getvalue('IDVAR') then on the new form insert a textbox (you can make it invisible) pass the IDVAR to the textbox (example Edit1) Use a DBquery , define a SqlParameter like [Param1]=Edit1
use Sql * from (your table name) where ID = '[Param1]'
You can not use variables on a SQL only parameters and you can not assign variable directly to parameters
Sorry for my English. It is not my native language.
I also love Longtion Application Builder I have been using it for a few months.
Posted 11 May 2012I bought longtion Application Builder about 2 weeks ago and i cant figure out what im doing wrong and or havent done. I have a table called users. i have this table on a form with a dbgrid that looks like a list box. Beside the list box their is a few buttons. Insert, Change, Delete. What im wanting is for the user to select a record and click change and it shows that user information on a form. When i tried to program sql, and or lookup. It always shows the first user. Idk what else to do. I really love longtion and i dont wanna change software. Somebody plzz help! Thnanks.
You want to se the information on a different form? or one the same form you have the Dbgrid?
- Member Title:
- New D.I.C Head
- Age Unknown
- Birthday Unknown
msebas hasn't added any friends yet.