Type: Posts; User: jp140768
Search took 0.03 seconds.
July 28th, 2009, 06:07 AM
I'm not really sure what you're trying to achieve here, but instead of having a sub query, could you replace it with an inner join? Refer to the table in the first From statement as a (for example),...
September 23rd, 2008, 02:58 PM
How about using a SET statement instead?
Not sure if you can use:
But you can definitly use Set @CustomerId = Ident_Current('Shippers') - well you can in SQL...
June 27th, 2007, 07:11 PM
Just a quick update, to say that I got it partially to work, I change the definition in my calling program to:
Dim aAccessories As List(Of...
June 27th, 2007, 06:05 PM
I am trying to write a system, for a shop that hires out equipment, when you hire certain pieces of equipment, you should be offered other pieces, eg if you hire a chain saw, you should...
June 27th, 2007, 10:15 AM
Attached is an example of a cursor being used, but from what I've read they're not always the most efficient way of working.
--Drop Procedure spRemoveAPAKDuplicates
June 27th, 2007, 10:07 AM
As Consola said you want to create a database where information is not being duplicated if possible.
Can you identify the unique characteristics of the data. You said you want to...
June 27th, 2007, 09:48 AM
Using Union, it shouldn't matter that there are a different number of fields in each table, unless you are doing Select *, provided you select the same number of fields in each table, and the...
June 27th, 2007, 09:43 AM
You can download the Express edition of Oracle for Linux from here:
SQL Server 2000, as far as I know, there is no free version of SQL Server 2000, the product you are looking for...
You say your using MDAC2.8, have you downloaded the Jet file (sorry I can't remember its name, but it will be in the download section of the Microsoft site), and its service pack?
Also DAO and...
This is more of a database question than a VB one isn't it? What databse are you using?
If I was doing it, I think I'd create a temporary table which contains records from the 8 group...
April 12th, 2007, 08:14 AM
When you say it is not installing, what is happening - are you getting an error?
April 4th, 2007, 10:54 AM
I did suggest that joins be used.
April 4th, 2007, 10:25 AM
Is OrderComplete a boolean / logical etc type field? If so, you shouldn't need the last line of your Where statement
The other thing, is what is the format of cdate? I'm wondering because if...
April 4th, 2007, 10:15 AM
DateDiff works on dates, not character fields, so you may need to convert the character field to a date time one.
The following might work for you:
cast(VESSEL_ETA as datetime)
April 4th, 2007, 10:08 AM
I think you'll get it in Jet 4 Service Pack 8, which can be downloaded from the Microsoft website.
March 28th, 2007, 06:46 AM
I have to be honest and say that I don't know what a .pdb database is, but could you use a "DSN-less" connection to various databases?
You say that you want to be able to read and write any kind...
March 28th, 2007, 06:41 AM
The above wouldn't have worked, because in your sub query you are selecting mutiple fields (SELECT *), you should only return one field, so that you Where Students.Employee_id could be equated to the...
March 28th, 2007, 06:36 AM
How often are you going to want to run this report? What database are you using?
If the job was only to run once, could you create a trigger which wrote the specific event to a table, which could...
March 27th, 2007, 04:15 AM
If I understand you correctly, you are going to use values on the second screen to insert a record into the database?
Is your problem in building the SQL statement? or in issuing the statement on...
March 26th, 2007, 08:33 PM
You may be able to use the @@Identity function?
March 26th, 2007, 08:28 PM
This website Connection Strings suggests that you can get MySql to work with .Net.
I would have thought that SQL Server should work fine with Visual C++.
Hopefully this will be of help to you...
March 26th, 2007, 08:18 PM
I wonder if the problem is actually with Amt_PD_MTD? If you select this field from the database, what value do you get? Does the problem occur for all records or only some?
I think in SQL...
March 26th, 2007, 08:06 PM
Most versions of SQL, contain a CASE statement. Look it up on your database documentation, it should help you out.
December 28th, 2006, 06:52 AM
Are these numbers or character based fields. If numbers, in your first question, you could use the BETWEEN operator (depending on your database, it might be RANGE).
I'm not really sure what...
December 28th, 2006, 06:48 AM
Are you getting any errors or messages?
Is there a condition on the Delete statement, that would prevent the records from being selected for deletion?
Can you post any code etc?
Click Here to Expand Forum to Full Width