Connect To Sql Server 2000 Through Prompt Dialog

Legacy Poster

• 23 de marzo de 2012 06:07

Hi there. I was wondering that if we can connect to SQL server database at the prompt dialog there. I will explain in more detail below.

Here is my scenario:

[u]Prompt dialog[/u]

Employee ID : <textbox here>

GRN: <textbox here>

P/N : <textbox here>

When the users enter the GRN and hit enter key, it will connect to SQL server and checking for that GRN.
If exist,it will return its part number at the next textbox which is on the same row with the GRN in the table.
If not,it will prompt out a message say that the GRN that you are enter is not existing.

Wondering that if that can be done using bartender.By the way,i'm using Bartender Enterprise Automation 9.4.
Any help would be much appreciated.Thanks.

0

• 

  Susan Chen

  Moderador

  ★ BarTender Hero ★

  • 23 de marzo de 2012 09:29
  Hi, tbzserge
  
  
  You can connected to SQL database and setup query prompt to see if this fulfill your requirement
  
  1) File-> Database connection setup -> choose SQL server and specify the SQL database
  2) Setup query prompt inside Bartender to select the record you want to print. You can reference our training video on how to setup query propmt http://www.seagullscientific.com/aspx/training-video-(selecting-records-from-a-database-at-print-time).aspx "Using a Query Prompt to select records"
  
  
  
  
  Thanks!

  0
• 

  Legacy Poster

  ★ BarTender Hero ★

  • 24 de marzo de 2012 01:35
  Hi Susan,
  
  Actually, i was looking for a more advanced answer.
  Yes,i have succeeded to connect to my SQL server.But i didn't intent to use query prompt to select records.
  What i wish to do is to search through the database from the prompt dialog just like i explained previously.
  
  Hope that anyone can clarify for me .Thanks

  0

Iniciar sesión para dejar un comentario.