Browse DevX
Sign up for e-mail newsletters from DevX

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



Building the Right Environment to Support AI, Machine Learning and Deep Learning

Select Statement Not Working

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?

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.



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