Search results for query: *

Hi Guys, I got a problem with ADO components. I've got a little program running on a server which does updates certain records to another sql server if certain conditions are met. That works fine, without any problem. The problem comes in when the connection fails (due to the other server being...

I can set the version options under the project options in Builder 6 (Version, Copyright, etc.). Is there a way to grab this data while the program is running to display it ? I'd like to display a splash with this information including the Build Version. Is this possible ?

We had a problem in our Office System and one of our tables got completely deleted, our backups are totally screwed and I'm having a very bad friday... The SQL server is still running, is it possible to reverse the delete by using the transaction log in some or other way. Where will I be able...

I'm trying to create the TADOConnection at runtime, with the following code : // the connection TADOConnection *Test; Test = new TADOConnection(NULL); // specify the connections string Test->ConnectionString = "Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security...

I'm busy developing an application that needs to connect to different sql servers on a network. Is there a way that I can search for these servers on the network and display them in a listbox. Other SQL question(s) : I know how to get a list of fields from a specified table. But How do I...

Hey Guys, I'm trying to connect to a SQL database, using ado inside a threads execute statement, but it's not working. I'm not sure if I can do this, can I ? Thanks,

Hey There, First off, thanks for all the help I've gotten so far. It's really helped me. Aha, but I have some more questions : I have a table full of records, and I want to create queries that do the following : 1) Delete all the records except the last x amount of records (ordered by date)...

It's easy doing a query to get the last x records from the data (they each have a date field) QUERY : select * from sourcetable order by date limit x But I need to get the records that were added the last x days ??

I'm currently developing an application which uses two indicators, which shows the network status (link to server) and sql status. I need a way to check for these two, without having my app to hang while waiting (or if either on of the two might be down). Network : I had this idea of pinging...

Hey There, is there a way to determine which we're the last x rows inserted into the sql table, without using some kind of reference field (datetime, etc.) ? Thanks for you help :)

I'm working on a new project for a factory and what we have done is basically setup a SQL server which keeps data from all the processes in the plant. We have workstations at the different processes which get data from the different machinery. These workstations feed the data into the SQL...