Re: [Clip] A newbie speaks....
- Hi Robert,
>In the ASCII files I mentioned are PART NUMBERS for the various^$GetField(number:row)$ I think. <g>
>components used in the schematics that the engineers create. I
>use NoteTAB to sniff out these part numbers from the ASCII files.
>The functionality I would LOVE to add is the ability for NoteTABI don't do ODBC, so I cannot help you further. Import file you
>to be able to take this Part Number and use it to query an ODBC
>database. Now as NoteTAB IS used to do Web Design. I am QUITE
>SURE there MUST be some sort of subroutine to do this. It's just
>I'm not SAVVY enough with this stuff to do it.
edited in NoteTab to ODBC? ^$GetField(number:row)$ and then Find
in ODBC file?
^!Find "ODBC file" Grin
Also, check out:
^!Save As (path\filename - makes/overwrites without prompt)
File | Export
Help | Help on Clip Programming
Subscribe, UnSubscribe, Options
> The functionality I would LOVE to add is the ability for NoteTAB to beHi
> able to take this Part Number and use it to query an ODBC database. Now
> as NoteTAB IS used to do Web Design. I am QUITE SURE there MUST be some
> sort of subroutine to do this. It's just I'm not SAVVY enough with this
> stuff to do it.
Although the clip methods for dealing with delimited txt files are great
(^$GetField(number:row)$ etc as Jody mentioned) notetab has no native way
of accessing databases.
However I do work with databases and have found notetab indespensible in
writing script to automate data manipulation and access routines.
Ms data access components can be found at.
Download the latest mdac release. now 2.7
To access database data I use the ADO com object instantiated in the Window
COM objects are language nuetral so you can use your favourite language to
instantiate theADO object and use it's properties and methods.
The active PERL disttribution last time I looked had some example ADO and
Since script is run in the console and has no gui
I use notetabs getout method to both run and get the output from the script
and I also pass arguments to the script using the same method.
The argument in your case would be the Part Number
;the location of script to run
;get rid of logo
^!Set %arg%="Part Number"
^!INFO ^$GetOutput(Wscript "^%file%" "^%hostOptions%" ^%arg%)$
The actual ado script would go something like this.
Instantiate ADO object
Connect to database use dns-less connection string
Contruct SQL string
Execute the SQL statement
And would be written in whatever scripting language you pefer.