Login | Register   
LinkedIn
Google+
Twitter
RSS Feed
Download our iPhone app
TODAY'S HEADLINES  |   ARTICLE ARCHIVE  |   FORUMS  |   TIP BANK
Browse DevX
Sign up for e-mail newsletters from DevX


Tip of the Day
Language: SQL Server
Expertise: Beginner
Nov 30, 1999

Select Statement Not Working

Question:
I am trying to code an event that will transfer information from the current form into the display of another form. Information like company name and address, and contact information. This should be done when I double-click on the DBGrid, which opens another form where I will have the contact and company information displayed in labels and a text box to input a journal entry.

My basic problem is that when I click on the grid the SQL statement I have written is not working where I have it selecting the information form the current table and comparing it to the DBGrid column index value for the CompanyId.

Any ideas on how to make this work?

Answer:
Although this is a front-end problem and beyond my expertise, I would suggest that you create a non-updateable view, the requery of which you could refresh when you change pages.

DevX Pro
 
Comment and Contribute

 

 

 

 

 


(Maximum characters: 1200). You have 1200 characters left.

 

 

Sitemap
Thanks for your registration, follow us on our social networks to keep up-to-date