devxlogo

Select Statement Not Working

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.

devxblackblue

About Our Editorial Process

At DevX, we’re dedicated to tech entrepreneurship. Our team closely follows industry shifts, new products, AI breakthroughs, technology trends, and funding announcements. Articles undergo thorough editing to ensure accuracy and clarity, reflecting DevX’s style and supporting entrepreneurs in the tech sphere.

See our full editorial policy.

About Our Journalist