f



Re: How to add records with 'Autonumber' property to a MS Access database using LabVIEW?

I applied the same approach as you guys have described,
however my problem starts before I get to autonumber. 
I have an issue feeding column (data) from "DB tool list column VI"
to "DB Tools insert data VI" .So when  I connect  column
output of "DB tool list vi" to column input of "Insert data Vi
" I get an error message "exception occurred in Microsoft OLE DB
Provider for ODBC Drivers, [Microsoft][ODBC Microsoft Access Driver] Syntax
error in INSERT INTO statement.." 

However, when I don?t connect column between those two vias, basically leaving
it blank ( it treats it as filling all the columns in database) and it works
fine that way. 
I talked to NI engineer and he couldn't figure out exactly what causes that
problem, ?DB Tools List column vi" outputs correct column info, which
corresponds correctly to my created data base. I am suspecting it could have
something to do with ODBC driver or version of Access that I am using. 

Access version is 2003, and I tried ODBC driver of 2002 & 2004 with the
same results.







 



Any help would be appreciated
0
x9561 (148442)
2/6/2006 8:41:17 PM
comp.lang.labview 35213 articles. 1 followers. vasusachin24 (1) is leader. Post Follow

0 Replies
1063 Views

Similar Articles

[PageSpeed] 33

Reply:

Similar Artilces:

Re: How to add records with 'Autonumber' property to a MS Access database using LabVIEW? #2
Hi Alex77, can you please post your vi? so that it will be easier to understand your problem. Any of the field has autogenerated values??? ...

How to add records with 'Autonumber' property to a MS Access database using LabVIEW?
I am trying to write to a MS Access database. Everything works fine as long as I add data to all records at the same time. The database I am using have two tables (just for testing) with a 'one-to-many' relationship between the two. They both have a PrimaryKey with the data type 'AutoNumber'. From what I understand those numbers should be automatically generated when new data is written to the DB. I can't get that to work with LabVIEW. I am using the function 'DB Tools Insert Data.vi'. According to the manual I should be OK with specifying the column I want to write...

Re: is there a way to set table entries to 'center justify' using property nodes in LabVIEW
LabviewGuru: I followed your instructions and have it all set up, but when I run the program I get two errors: 1.  Error 1057 occured at To More Specific Class Possible reason(s): Type mismatch: object cannot be typecasted to the specific type 2.  Error 1055 at Property Node (The string property node) Possible reason(s): Object reference is invalid. For your information I am using LabVIEW 7.1 and this error occurs whether I do justification, font properties, etc.  I am taking a table reference, getting the active cell, casting it to a string type and using a string property node to change the font. Any ideas? ...

'''''''''''''The Running Update/Append Queries Using VBA code Ordeal''''''''''''''
Hello fellow programmers, I am trying to run an append/update query from code, a command button on a form initiates the queries. the format i am using is; _____________________________________________________ SELECT "criteria" FROM "criteria" WHERE "criteria" UPDATE/APPEND "field selections" RecordSource "qryExample" = above text strings" _______________________________________________________________________ When i am running a SELECT query in this manner it works fine with no problems, and accepts the values of specified linked form fields. This never works when doing an APPEND/UPDATE query. It can never find the values of linked form fields, Access always asks for the parameter value of the field(s) in question, or Access comes up with an error 3323 - No recordset. I am sure there are other people that have had this problem. What is the difference between Select queries and append/update queries? the append/update queries never seem to be able to find values in linked form fields. Can anyone shed any light on this or point to a knowledgebase Item, or even recommend a book focusing on this subject, I will go and buy it now. I have been for up 2 nights trying to acomplish this and now considering suicide, please help. Thanks In advance, Aaron. I know of two ways you can accomplish this. 1. You can create the SQL script for you append or update query and run the script with DoCmd.RunSQL. 2. You can create a...

Unable to install labview in the new mac using the 'labview CD for Power Mac'
I have got a 'Labview full development system for power macintosh'. I have to use labview for some application and so I tried installing labview in my imac using this CD. The CD gets ejected out by itself. I tried it in a Mac laptop. There it opened, but when I try to install it, it gave the following message: 'You can't open the application 'Install Labview' because the classic environment is no longer supported'. Please note that the macs that I used are Intel based. What is the cause of this problem? What is the solution?The version of the software is : 6.0Please do the needful.Thankyou,Pavithra Souriraj The version you are trying to install was apparently written for Mac OS 9 or earlier, hence the reference to the Classic environment. The Classic environment is an emulation of OS 9 under OS X. However, Apple did not start using Intel processors until several years after the introduction of OS X, so they (Apple) did not develop an OS 9 emulator which will run on Intel based Macs. You cannot run LV 6 on an Intel based Mac. This is an Apple issue, not a National Instruments issue. LV 6 runs fine under OS X on a PowerPC Mac, as do several other versions.You will either need to get an older Mac or a newer version of LV. I am not sure which is the earliest version which will run on an Intel Mac.LynnUsing LV on the Mac since version 1.2 Hello Pavithra, Thank you for contacting National Instruments.  Please look at this article for your ...

'''''''''''''The Running Update/Append Queries Using VBA code Ordeal'''''''''''''' #2
Hi, Thanks for ur help there HJ. I know how to do the tasks you specified there. I would like for the update query to use field values from some of the fields on the form (frmInvoices) such as InvoiceNumber, DateFrom, DateTo. My problem is that an append/update query can't find the values in the open Form (frmInvoices) when I specify them as; [Forms]![frmInvoices]![InvoiceNumber] a select query has no problem finding the field values on a form. please help. Aaron Hi Aaron, Could you post the entire code that you are having trouble with? Now it is not possible to see what goes wrong. HJ "Aaron" <aaron@rapid-motion.co.uk> wrote in message news:260d7f40.0408120245.2f3d01f8@posting.google.com... > Hi, > > Thanks for ur help there HJ. > > I know how to do the tasks you specified there. > > I would like for the update query to use field values from some of the > fields on the form (frmInvoices) such as InvoiceNumber, DateFrom, > DateTo. My problem is that an append/update query can't find the > values in the open Form (frmInvoices) when I specify them as; > > [Forms]![frmInvoices]![InvoiceNumber] > > a select query has no problem finding the field values on a form. > > please help. > > Aaron First off, if you are not always using all the parameters specified in your form, then you have to add parameters to your query on the fly. Also, you can't just do something like qdf.SQL = "SE...

Re: '^=' and '~='?
Duckhye, According to the doc ( http://xrl.us/befwjx ) they, and one other set of characters, and the mnemonic 'NE' all represent 'NOT EQUAL'. Art ------- On Wed, 11 Feb 2009 16:52:40 -0600, Duck-Hye Yang <dyang@CHAPINHALL.ORG> wrote: >Hello, >What is the difference between '^=' and '~='? > >Thanks, >Duckhye ...

Can I use LabVIEW to load data directly into system memory? The serial card I'm using isn't supported by NI nor does VISA recognize it. I'm using a Win32 function to read the data from the card
Can I use LabVIEW to load data directly into system memory from a VI? The serial card I'm using isn't supported by NI nor does VISA recognize it. I'm using a&nbsp;Call Library&nbsp;function to read the data from the card and now I want it to go directly to system memory. The data is being received at 1Mbps. &nbsp; Thanks 1.You will most likely crash your system trying to write meg's/sec of data to system memory. LabVIEW has it's own memory manager and manages data for you. If you getting data to LabVIEW, I hope for the processinfg purposes. You didn't mentioned what do you want to do with that heap of data. 2.You probably can access your data from your card using VISA if you know card's registers and memory i/o block as BIOS assigning this block to your card. Search through VISA documentation and NI site how to do that. ...

Using Access to 'access' an sql database on a webserver
Is this possible? I know about a bit about ODBC and found how to import an ODBC database stored on the computer, however I am after accessing an SQL database stored on a webserver. I'd like to keep it up to date, but that could probably be done with a macro. At the moment I'm just considoring possible options, so just need to know if it can be done, how easy and a rough idea of how. Any help would be much appreciated! Flic On 6 Oct 2006 03:59:25 -0700, "Flic" <FelicityP@gmail.com> wrote: I typically create an ADP, then connect to such db specifying the IP address and the u/pw I got from the ISP. -Tom. >Is this possible? > >I know about a bit about ODBC and found how to import an ODBC database >stored on the computer, however I am after accessing an SQL database >stored on a webserver. I'd like to keep it up to date, but that could >probably be done with a macro. > >At the moment I'm just considoring possible options, so just need to >know if it can be done, how easy and a rough idea of how. > >Any help would be much appreciated! > >Flic Yes, you can connect to the sql server. However, how that server is exposed to the wild wild internet is another matter!! Most (if not all) administrators of their web sites NEVER EVER allow their database server to be exposed to a wide open port on the internet. So, can you do this...sure. However, you need go to web server, and setup the permissions to a...

A 'datagrid' or 'table' in MS Access
I'm developing a form in Access with VBA. But i didn't found a good way to display the results of a query. I would like to show the results in a way simular to a table in access. (and not as a subform) Any suggestions how to implement this ? Regards, Jon S. wrote: > I'm developing a form in Access with VBA. > > But i didn't found a good way to display the results of a query. > > I would like to show the results in a way simular to a table in > access. (and not as a subform) > > Any suggestions how to implement this ? Ummm.... A subform in datasheet view? A continuous subform with fields side by side to look like a datasheet? A listbox? Br@dley I used a subform in datasheet view, and it starts to look as i intended it. Thanks for the reply Regards, ...

How do I set MS Access NOT to use my profile's 'My Documents'
Hello All, I need to set Access to use my local folder, and not my 'My Docs' folder which is in a netwrok drive. I did the setting thru' options, but when I logged in again, it was pointing to 'My Docs' folder. How do I set this folder permanently? Regards K. Lakshmanan On 4 Mar 2006 01:53:07 -0800, lakshmanan.kk@gmail.com wrote: >Hello All, >I need to set Access to use my local folder, and not my 'My Docs' >folder which is in a netwrok drive. >I did the setting thru' options, but when I logged in again, it was >pointing to 'My Docs' folder. >How do I set this folder permanently? >Regards >K. Lakshmanan Tools/Options/General/Default database folder Wayne Gillespie Gosford NSW Australia Thanks. I did that and when I logged out of XP and login again, it was pointing to My Documents. Now I found a setting (in three places, if I am right) in registry called 'default database directory' which was setting this value. I changed that to my local folder, and now it is fine. Thanks anyway. Regards. ...

Re: if str_mo not in ('','.') and str_da not in ('','.') and str_yy not in ('','.') Any shorter ? #2
Igor, There are many ways to make it more concise, however the parsimony is likely to be achieved at the expense of clarity. For instance, the expressions length ( input (mm||dd||yy, $10.) ) > 2 length ( compress(mm||dd||yy, ' .') ) > 2 and like might be somewhat shorter than the original, but they will execute slower, and their intent is far less eminent. Since it appears that you are trying to validate the components of a date, maybe it is not a worthless idea to try the date informat conforming to the mask you are testing. Say if all the pieces are 2-digit, the expression input (mm||dd||yy, ?? mmddyy6.) will return a missing value for the case you are testing and also if any irregularities in the input value that prevent it from being interpreted as a valid date should be found. And if you want a note in the log to alert you about it, leave one of the question marks off. Kind regards, ================= Paul M. Dorfman Jacksonville, FL ================= >From: Igor Kurbeko <ikurbeko@ATHEROGENICS.COM> >Reply-To: Igor Kurbeko <ikurbeko@ATHEROGENICS.COM> >To: SAS-L@LISTSERV.UGA.EDU >Subject: if str_mo not in ('','.') and str_da not in ('','.') and str_yy > not in ('','.') Any shorter ? >Date: Wed, 22 Oct 2003 17:13:37 -0400 > >Hi, there. > > > >I'm just curious if it ever dawned on anybody how to abbreviate this >line : > >if ...

Re: Using 'varargs' vs 'stdargs'
This is a multi-part message in MIME format. --------------040007030802060004000808 Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit Aaron and Andreas, I don't know anything about 'stdargs' either, but a key quesiton is whether it is just a change to the syntax of varargs handling or the way it is actually achieved (which I think for varargs was by passing a count of the number of args followed by the args themselves on the callstack, but I may be wrong - anyway it doesn't really matter, what matters is, has it change...

Re: if str_mo not in ('','.') and str_da not in ('','.') and str_ yy not in ('','.') Any shorter ? #4
Igor, Without robust error checking: %macro check ( vars , values , op = in /* not in */, con = and /* or */ ) ; %local i w ; %let i = 1 ; %let w = %scan(&vars,&i) ; %do %while ( %length ( &w ) > 0 ) ; %if &i > 1 %then &con ; &w &op &values %let i = %eval ( &i + 1 ) ; %let w = %scan(&vars,&i) ; %end ; %mend check ; option mprint ; data w ; retain x y z "a" r " " s t "a" a b 99 c . ; if %check( x y z , ('','.'), op = not in ) then put "Igor" ; else put "Problem some x y or z are bad" ; if %check( r s t , ('','.'), con = or ) then put "Problem some r s or t are bad" ; if %check ( a b c , ( . 99) ) then put "Problem all a b and c are bad numerics" ; run ; I am sure there is code something like this in the archives but do not want to find it. IanWhitlock@westat.com -----Original Message----- From: Igor Kurbeko [mailto:ikurbeko@ATHEROGENICS.COM] Sent: Wednesday, October 22, 2003 5:14 PM To: SAS-L@LISTSERV.UGA.EDU Subject: if str_mo not in ('','.') and str_da not in ('','.') and str_yy not in ('','.') Any shorter ? Hi, there. I'm just curious if it ever dawned on anybody how to abbreviate this line : if str_mo not in ('','.') and str_da not in ('','.&#...

Re: if str_mo not in ('','.') and str_da not in ('','.') and str_ yy not in ('','.') Any shorter ? #3
> From: Igor Kurbeko [mailto:ikurbeko@ATHEROGENICS.COM] > I'm just curious if it ever dawned on anybody > how to abbreviate this line : > > if str_mo not in ('','.') > and str_da not in ('','.') > and str_yy not in ('','.') %*in autoexec:; %Let Blank = Blank; %Let Invalid = Invalid; %*in aFormat; PROC Format; value $StrValu %*somevalues = 'ok'; '','.' = "&Blank." %* other = "&Invalid."; ; %*in Program; if put(Str_...

Using Labview 6.1 on Linux, the 'Current VI's Path' function...
Using Labview 6.1 on Linux, the 'Current VI's Path' function returns an incorrect and unuseable path. 'Current VI's Path' is returning my home director rather than the vi path and it has a back slash '/' at the end which means I can not append to it. Is this a bug? Hi Jack, I emailed you the my suggestions below "I tried running LabVIEW 6.1 on a Linux machine here running red hat 7.2 and I couldnt reproduce you issue. I got the full pathname '/home/login_name/untitled1.vi. I even tried LabVIEW 7 and that worked fine too. This maybe a silly questi...

'^=' and '~='?
Hello, What is the difference between '^=' and '~='? Thanks, Duckhye ...

'is not' or '!='
A newbie question to you; what is the difference between statements like: if x is not None: and if x != None: Without any context, which one should be preferred? IMHO, the latter is more readable. On 2014-08-18 21:35, ElChino wrote: > A newbie question to you; what is the difference between statements > like: > if x is not None: > and > if x != None: > > Without any context, which one should be preferred? > IMHO, the latter is more readable. > "x == y" tells you whether x and y refer to objects that are equal. "x is y" tells you whether x and y actually refer to the same object. In the case of singletons like None (there's only one None object), it's better to use "is". "ElChino" <elchino@cnn.cn>: > A newbie question to you; what is the difference between statements > like: > if x is not None: > and > if x != None: Do the following: take two $10 bills. Hold one bill in the left hand, hold the other bill in the right hand. Now, the bill in the left hand "is not" the bill in the right hand. However, the bill in the left hand "==" the bill in the right hand. > Without any context, which one should be preferred? > IMHO, the latter is more readable. In almost all cases, both tests would result in the same behavior. However, the "is not" test is conceptually the correct one since you want...

Re: "Hi,I'm having problems controlling the Agilent E4422B Signal Generator with Labview. When using the Labview driver functions such as initialize instrument I always get an Error -1074135040
Hi, Brooks. Attached please find the files containing all the information concerning my attempt to control the Agilent E4438C. Hope you can make sense of it and help me. &nbsp; Regards isaac nireport.txt: http://forums.ni.com/attachments/ni/170/191414/1/nireport.txt Capture.spy: http://forums.ni.com/attachments/ni/170/191414/2/Capture.spy CaptureSpy.doc: http://forums.ni.com/attachments/ni/170/191414/3/CaptureSpy.doc Hi, If this driver supports multiple instrument models, then you will probably have to set the model in the default settings in MAX. Regards Ray FarmerMessage Edited by Ray Farmer on 06-22-2006 01:54 PM Hello Isaac,From the Spy capture it appears that you are sending an Asynchronous write command.&nbsp; The error that appears indicates that the write was successful, but was actually synchronous rather than asynchronous.&nbsp; This is probably due to a configuration setting for the instrument.&nbsp; As Ray points out, you may need to clarify which instrument you are using if this driver supports multiple models or check your instrument's configuration. &nbsp; Regards,AngelaApplications Engineer ...

Re: index and queries using '<' '>'
At 16:23 18/11/2004 +0100, Martijn van Oosterhout wrote: > The system seems to think that a scan is cheap because the table is so > small. The table currently contains just over 10000 elements. So 238 rows is a small part of it. > Have you ever ANALYZEd that table? Yes. That and reindex (in case of a problem). I have also tried ALTER TABLE ALTER COLUMN SET STATISTICS, but without improvement. > Also, EXPLAIN ANALYZE gives a much better idea of what is going on... You mean ANALYZE VERBOSE ? Since the table is still growing, and the amount of rows in the reply of ...

Re: '^=' and '~='? #8
32 libname erap 'T:\9SOW\AHRQ_E Rap\Data\E-RAP Data\December 2008'; NOTE: Libref ERAP was successfully assigned as follows: Engine: V9 Physical Name: T:\9SOW\AHRQ_E Rap\Data\E-RAP Data\December 2008 33 options nodate nonumber formdlim='-'; 34 /* Program: E-RAP Load XML to SAS with map v2.sas*/ 35 /************************************************************************* 36 Update path and file name below. 37 **************************************************************************/ 38 %let data_path = T:\9SOW\AHRQ_E Rap\Data\E-RAP Data\December 2008\Raw XML Data; 39 %let input_file = 035151_12232008.xml; 40 **************************************************************************; 41 42 filename xml_lib "&data_path.\&input_file."; 43 filename SXLEMAP "&data_path.\xml_map_v2.map"; 44 libname xml_lib xml xmlmap=SXLEMAP access=READONLY; NOTE: Libref XML_LIB was successfully assigned as follows: Engine: XML Physical Name: XML_LIB 45 libname erap "&data_path"; NOTE: Libref ERAP was successfully assigned as follows: Engine: V9 Physical Name: T:\9SOW\AHRQ_E Rap\Data\E-RAP Data\December 2008\Raw XML Data 46 * Read XML file into SAS data set; 47 data erap.Sabino; 48 set xml_lib.E_rap_episode_record; 49 run; ERROR: There is an illegal character in the entity name. encountered during XMLInput pa...

Re: '^=' and '~='? #3
On Wed, 11 Feb 2009 17:03:27 -0600, Joe Matise <snoopy369@GMAIL.COM> wrote: >No difference that I know of ... SAS has all sorts of things you can use as >operators. > >LT,< >LE,<= >ne, ^=, ~=, <> in some contexts at least hi, at least in the data step, <>, does not mean not equal, it is the MAX operator, returning the larger of the two. Similarly there is MIN operator, ><. in MS Visual Basic, though, "<>" means "not equal." There are three symbols used as the logical operators OR and another three for logical NOT, but the availability of these symbols are platform dependent. Read about 9.2 (data step) language Operators at http://tinyurl.com/4w5hen or http://support.sas.com/documentation/cdl/en/lrcon/59522/HTML/default/a00078 0367.htm hth. Cheers, Chang ...

Re: '^=' and '~='? #9
On Thu, 12 Feb 2009 08:58:21 -0600, Joe Matise <snoopy369@GMAIL.COM> wrote: >Yeah, <> works in PROC SQL, wasn't sure about elsewhere... thanks for >confirmation! Didn't know about the MAX operator, that's interesting. .... hi, In proc SQL, I do get a note saying that: NOTE: The "<>" operator is interpreted as "not equals". In general, i find that we have different sas expressions, mostly identical one another. Still, there remain definite differences among all of these expressions: (1) data step expressions (2) where statement expressions (3) sql-expressions used in proc sql (4) macro expressions this is a less than ideal situation :-) but this may be an inevitable consequence of sas' being around for a long time. cheers, chang ...

Re: '^=' and '~='? #6
On 2/12/09, Chang Chung <chang_y_chung@hotmail.com> wrote: > On Wed, 11 Feb 2009 17:03:27 -0600, Joe Matise <snoopy369@GMAIL.COM> wrote: > > >No difference that I know of ... SAS has all sorts of things you can use > as > >operators. > > > >LT,< > >LE,<= > >ne, ^=, ~=, <> in some contexts at least > > hi, > at least in the data step, <>, does not mean not equal, it is the MAX > operator, returning the larger of the two. Similarly there is MIN operator, > ><. in MS Visual Basic, though, "<>" means "not equal." > There are three symbols used as the logical operators OR and another three > for logical NOT, but the availability of these symbols are platform > dependent. Maybe good reason to use mnemonic equivalents. 882 data _null_; 883 a = .v MIN .z; 884 b = .v MAX .z; 885 ax = .v >< .z; 886 bx = .v <> .z; NOTE: The "<>" operator is interpreted as "MAX". 887 c = .A NE .A; 888 put (_all_)(=);; 889 run; a=V b=Z ax=V bx=Z c=0 ...

Web resources about - Re: How to add records with 'Autonumber' property to a MS Access database using LabVIEW? - comp.lang.labview

Resources last updated: 3/29/2016 12:33:37 AM