msebas's Profile User Rating: -----

msebas's Photo
Reputation: 0 Apprentice
Group:
New Members
Active Posts:
2 (0.01 per day)
Joined:
11-May 12
Profile Views:
101
Last Active:
User is offline May 17 2012 04:34 AM
Currently:
Offline

Previous Fields

Dream Kudos:
0
Icon   msebas has not set their status

  1. Awards
  2. About Me
  3. Blog

Posts I've Made

  1. In Topic: Longtion Application Builder.

    Posted 11 May 2012

    View Postnltaylor93, on 30 April 2012 - 05:56 PM, said:

    View Poste_i_pi, on 30 April 2012 - 05:48 PM, said:

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

  2. In Topic: Longtion Application Builder.

    Posted 11 May 2012

    View Postnltaylor93, on 29 April 2012 - 05:41 PM, said:

    I 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?

My Information

Member Title:
New D.I.C Head
Age:
Age Unknown
Birthday:
Birthday Unknown
Gender:

Contact Information

E-mail:
Private

Friends

msebas hasn't added any friends yet.

Comments

msebas has no profile comments yet. Why not say hello?