tomlogic

This is a school related question. My lab says the following:

1. Add a new Vendor table
a. See table above for fields and data types
b. Use your username as the table definition, i.e., userid.Vendor, instead of Demo
c. Add Primary key ProductNo as a Constraint

Okay, I created the table with the fields and data types. Now when I go to add the primary key with the constraint and I get
ERROR at line 2:
ORA-00904: “VENDOR_NO”: invalid identifier

Can i use the bind variable inside a procedure?
and the query like update emp set empname=:name where empno=:no;

but i work like update emp set empname=&name where empno=&no inside procedures it works properly

Code: ( text )
declare
i number:=0;
begin
while i<3
loop
update dept set empno=&empno where dname=’&deptname’;
i:=i+1;
end loop;
end;

I’m hoping you can help me with my form. I used some of the script you ga
ve in this discussion but it’s not working for me for some reason. Can you check this out a
nd tell me what you think? http://www.rwgarcia.com/forms/form.html When I test the form it just
goes to the formhandler.asp page.

First of all, if you look at my csv file here: http://www.rwgarcia.com/forms/veggiechips.csv, there are a ton of commas being inserted. It seems like there are more everytime there is a new entry. Do you know why it’s doing that? My client is using Excel to open the file and all those extra commas seem to get in the way.

Also, do you know how can password protect the csv file?

Thank you thank you thank you!!!

When I have entered the below code and tested it, it let’s me input hours, I press calculate then says compile error, method or data member not found. I press ok and .text is highlighted. I have noticed when I delete .text and type it again only 4 options instead of loads comes up. So really it’s not letting me selct it as .text.

I was up til 4 this morning with this so any help and I would be eternally grateful.

I have some problems regarding text filtering with Visual Basic.
In order to filter only some text lines I want to make a copy of the file as a temporary one, read this copy as a file input via basic and print out to the file.
The original text file looks as follows:
2.11.2007 11:35:36 The new source ‘SOCKET:192.168.0.75:1458′
has been accepted
22.11.2007 11:34:42 Network Services stopped (GT EX TEST)
22.11.2007 11:34:52 Network Services started (GT EX TEST)
….
There are hundreds of these messages. This text file is log file of a software.
In a copied text file I only want to copy the text lines (system messages) which I need to see.

I will be really grateful if you give
me some tips for the solution of the problem.