f



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???
0
x9561 (148442)
4/14/2008 9:10:05 AM
comp.lang.labview 35213 articles. 1 followers. vasusachin24 (1) is leader. Post Follow

0 Replies
1451 Views

Similar Articles

[PageSpeed] 8

Reply:

Similar Artilces:

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 v...

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...

'''''''''''''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: 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.&nbsp; Error 1057 occured at To More Specific Class Possible reason(s): Type mismatch: object cannot be typecasted to the specific type 2.&nbsp; 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.&nbsp; 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? ...

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: '^=' and '~='? #2
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 eq, = <<< these actually DO have a difference or two, particularly as relates to assignment I don't recall where the full list is, but http://support.sas.com/onlinedoc/913/getDoc/en/lrdict.hlp/a000202951.htm#a000290128has the list of them usable in WHERE statements (which, IIRC, is slightly greater than that of normal code, as it allows for SQL syntax in ways the rest of SAS does not). -Joe On Wed, Feb 11, 2009 at 4:52 PM, Duck-Hye Yang <dyang@chapinhall.org> wrote: > Hello, > What is the difference between '^=' and '~='? > > Thanks, > Duckhye > ...

Access 2.0 Help mentioned 'record numbers' frequently but nowhere did it ever say how to determine a given record's record number
Anyone remember how to determine a particular record's record number (Access 2.0 table question)? You could get the number from the AbsolutePosition property of the Recordset. Details: http://allenbrowne.com/casu-10.html -- Allen Browne - Microsoft MVP. Perth, Western Australia. Tips for Access users - http://allenbrowne.com/tips.html Reply to group, rather than allenbrowne at mvps dot org. "MLH" <CRCI@NorthState.net> wrote in message news:qkoo90t2nta3v281a2kn7bkp2ru8jjdii5@4ax.com... > Anyone remember how to determine a particular > record's record numb...

Re: how to plot using different 'v' and 'cv' in proc gplot? #2
>On Fri, 21 Apr 2006 09:31:39 +0800, bx.miao <032015214@FUDAN.EDU.CN> wrote: (look far down) Hi bx.miao , I think you need two variables to plot with different colors and symbols. The 'overlay' option helps you here. Here I've just faked the data using missings. data test; input r thegma; if (r=0 and thegma=0.1) or (r=0.5 and thegma=0) then do; r2=r; thegma2=thegma; r=.; thegma=.; end; cards; 0 0.1 0.1 0.3 0.2 0.4 0.5 0 ; run; goptions reset=all ; symbol1 color=red value=dot; symbol2 color=blue value=X; proc gplot ; plot r*thegma r2*thegma2 / overlay ; run; quit; >hi all, > >I want to plot with different 'c' and 'cv' , how can i do it? > >for example, >data test >input r thegma, >cards, >0 0.1 >0.1 0.3 >0.2 0.4 >0.5 0 >, >run; >proc gplot, > >plot r*thegma, >run; > >but I want (0,0.1) and (0.5,0) with differnt symbol.For example,I will >use 'v=x cv=red' >to display (0,0.1) and (0.5,0) ,and use 'v=dot cv=blue'to display the >others. > >how can I do this function? > >thanks in advance. > >bxmiao ...

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.&nbsp; Please look at this article for your ...

Re: Using 'varargs' vs 'stdargs' (also links to libXt.so etc.) #2
This is a multi-part message in MIME format. --------------090706050506090405020205 Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit Aaron Sloman wrote: >>This is important because some native pop >>code in the Xt interface invokes external C procedures using the varargs >>protocol, but possibly not via an actual C wrapper, so it wouldn't have >>been caught by a global change to C files. If anyone thinks there's an >>issue here, I could try and rediscover whether/where it happens in more >>de...

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 ...

Playing & recording WAVE-type sound in MS Access
I've followed the instructions found on Microsoft's site... http://support.microsoft.com/default.aspx?scid=kb;en-us;149119&Product=acc97 Here are those instructions... To play and record sounds, follow these steps: Create the following new table in Design view: Table: Messages ----------------------- Field Name: Message Data Type: OLE Object Save the table as Messages, and then close the table. Create a new form in Design view based on the Messages table. Add the following controls to the form: Bound Object Frame: Name: Message ...

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 menti...

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...

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' fo...

Re: '%let' within an 'if-end' #2
> From: Shahmeer Aarbi > I am trying to use a %let statement within an if-end block. > But the %let statement gets executed even when the 'if' > statement is false. How do I fix this? you can't mix SAS statements and macro statements: they are compiled at different times. > Basically here is my issue - I have a dataset (called flags) > like this flagname value > primary 1 > secondary 0 > > > I am trying to store these values as a macro variables > because I want to perform certain steps depending on whether > the flag is on or off. To pick these as macro variables, I > have this data step: > *initialize; %Let PrimaryFlag = .; %Let SecondaryFlag = .; data _Null_; set flags; call symputx('primaryflag',flagname eq 'primary' and value eq 1); call symputx('secondaryflag',flagname eq 'secondary' and value eq 1); stop; %Put _global_; note assumption: only one row in data set flags otherwise your macro variables will have the values in last row of data set Flags. and you want to call your macro with the global macro variable: %PrimaryFunction(PrimaryFlag = &PrimaryFlag.); Ron Fehd the macro maven CDC Atlanta GA USA RJF2 at cdc dot gov > > if flagname = 'primary' and value = 1 then do; > %*let primaryflag = 1; *this statement is executed even > when the if condition is false. I don't want that; > end; > > if flagname = '...

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 &qu...

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...

Seeking 'LabVIEW 2' materials
Greetings: We have recently acquired LabVIEW 2.2.1 on Macintosh sans manuals; if you have the books (especially function references) and could lend them we will scan them and return them with the electronic versions. Finding collections of LabVIEW 2 VIs and instrument drivers is another quest. All help greatly appreciated. Michael Grigoni Cybertheque Museum (remove NOSPAM from e-mail address to reply) Hello Michael =96 Unfortunately our ability to help you is very limited. We do not provide official support so far back. However, I tried to look for some documents that might be helpful fo...

'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: [wxMac 2.6.3] 'Preferences....' menu access #2
Hi Hartwig=20 > but when I move it from the help menu to the app menu I=20 > should have the about menu item twice: one is automatically=20 > generated and the other one is moved by myself to that location. Or? no, you just create a help menu item with wxID_ABOUT in your code, and wxMac hides that line from the help menu and associates the app menu about item with that menu item > What is BTW the item id of the about menu that is=20 > automatically generated? the mechanism works as explained above, no new ID, it is done by mapping (have a look at how it works w...

RE: [wxMac 2.6.3] 'Preferences....' menu access #2
Hi Hartwig > thanks for information. >=20 > ad 1) is wxID_PREFERENCES id a standard? I could not find it in the > 2.6.3 documentation file (wx.htb). not in the docs I'm sorry ... > ad 2) no, I did not add an item because I get the wxID_ABOUT=20 > menu item anyway below the 'application menu'. I want to use=20 > this one rather than creating an additional about menu item=20 > in the help menu. think crossplatform : you add the menu item to your help menu and on mac I move the menu item from that place to the app menu .. Best, STefan ...

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

Resources last updated: 3/19/2016 11:12:00 AM