Search results for query: *

Brendan, I did as you suggested, on a demo database and your SQL suggestion. The result is another error: The specified field <field> could refer to more than one table listed in the FROM clause of your SQL statement. (Error 3079) So I tried the following: DELETE fvmCalResults.* FROM...

I have two tables of the same structure in an Access DataBase. One table is linked from an ODBC source and the other is an Access table. I want to delete the data in the Access table that contains duplicate information from the ODBC table. The tables are joined by the primary key. When I try...

How can I synchronize my field laptops with my server machine on a periodic basis? My field laptops Retrieve/Modify/Add information to their local database. When that laptop gets back, I want to update the central server, then update the local laptop again. The central server is only used to...

Also, his notes have a reference to Sysbase SQL Anwhere 5.0, ISQL.

The original should be automatically discarded (set to nothing) when you create the second object. This happens &quot;behind the scenes&quot; and you should not have to explicitly do it. One good reason to do it explicitly is that you know exactly when (in your flow of code) the object is...

I would make a public BAS module that contained the Public variables that are common to multiple forms. Then anywhere in your code, you can refer to those variables. More complexly, you could have a Public variable in each form that you could set before you show that form, for example...

Very broad question. There is no right answer. It all depends on what kind of applications you want to develope. I have written in Assembly, C, C++, Visual Basic, Quick Basic, VB Script, and a few more. Each one has or had its place. I found Visual Basic to be the simplest GUI based...

I am not sure what is being asked, but here is some more information. I am using Sysbase SQL. In VB, I am using DAO 3.6 object library and connecting with ODBC.

I am trying to write an SQL query that selects specific records from an ODBC database and outputs them to a text file in a specified format. A co-worker of mine recently attended a workshop which gave us the idea. Unfortunately, he is not an SQL person and has no idea of how it is soppose to...

There are two common image viewing controls in VB, Picture Box, and Image Control. If you use the Picture Box, then you need to fit the image before you load it into the control. If you use the Image Control, then all you need to do is set the property Stretch = True. Its been a couple of...

I too would like to know this. I posted a similar question last week, but I still do not have any responses. If you find something, I would like to know.

That did not seem to work, if you don't mind, can I send you an email with a sample database?

I am using a VB6 application to connect to a Sysbase SQL database. The problem I have is that I first need to launch the Sysbase DBClient.exe application in order for my VB code to connect. I desire to connect completely by code, without having any user interaction. I tried to use the VB...

I have a very simple query based from a very simple table that I cannot get to work. Table1: Field1: TAG, Text Field2: TimeModified, Date Query1: SQL: SELECT Table1.TAG, Table1.TimeModified FROM Table1 WHERE (((Table1.TimeModified)=#4/12/2001 10:39:35#)); The output of the Query is nothing...

This may help a little. I found a reference to that file extention. .rtp Rtpatch software update package data file Here is a WebSite for that company: http://www.pocketsoft.com/products.html

I am using a VB6 application to connect to a Sysbase SQL database. The problem I have is that I first need to launch the Sysbase DBClient.exe application in order for my VB code to connect. I desire to connect completely by code, without having any user interaction. I tried to use the VB...

It seems that I need to remove the links to each other, replicate both databases, and write my code to juggle access to both databases. I don't see too many drawbacks other than writing a bunch of code to handle it. JerryDennison stated that replicating both db's is not a good idea, what are...

I have an Access database(DB1) that contains a couple of tables linked to another Access database(DB2). Both databases are on a network drive (ie: \\Computer1\folder\db1.mdb, \\Computer1\folder\db2.mdb). I then used the Access replicate feature on DB1 so that my technicians can use the...