2. ASPRunnerPro General questions
  3. Insert Into
This topic is locked

Insert Into

 		3/18/2003 1:56:11 PM
ASPRunnerPro General questions
author

help me, im getting an error in "inserto into", but none of my tables or fields are reserved words, i just cant understand.
Please help me with this one,
TIA
Miguel <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=question&id=20&image=1&table=forumtopics' class='bbc_emoticon' alt=':(' />
Sergey Kornilov admin 3/18/2003

Miguel,
could you please zip and send me the whole content of your output folder including your database?
I'll test it on my local box and find what's wrong.
Just send it to support AT xlinesoft.com
Sergey Kornilov
500010 3/20/2003

Thanks very much, its working now.

Just one more question, is there any way i can use a combo box in the search field?
TIA
Miguel
Sergey Kornilov admin 3/20/2003

Miguel,
could you give me an example of combo box usage in a search field?
Sergey Kornilov
500011 3/21/2003

Sure Sergey,
Lets imagine i wanna search in a table where i just wanna alow search where field1 must be equal only to "type1" "type2" and "type3", and ignore all other options.
for example: I have 3 divisions of the company and wanna alow search of contacts only for those 3, so the user click on the combo box and "filter" only the contacts that belong to that division.
hope that this helps,
TIA
Miguel
Sergey Kornilov admin 3/21/2003

Miguel,
I see what you saying.
You can do this manually only.
Sergey Kornilov
A
 		avion 2/22/2005

HOW TO DO IT MANUALLY
Sergey Kornilov admin 2/22/2005

Avion,
ASPRunnerPro v3.1a can do this.
Set "Edit as" type of this column to "Lookup wizard" to make it appear as a drop-down box on the Advanced search page.
Here is the link to download ASPRunnerPro 3.1a:

http://www.asprunner.com/files/asprunnerpro31a.exe
A
 		avion 2/22/2005

i m looking at multi combo

while adding / editing
http://www.bookryanair.com/skylights/cgi-b...nguage=EN&fr=ry