Yes! MY Problem is ONLY PRINTINTING. Acording to SQLPLUS manual SPOOL OUT closes SPOOL FILE AND send it to DEFAULT PRINTER.FIrst part(CLOSE FILE) works properly,second one - dos'nt. I'm interesting to print directly from SQLPLUS. Of course I can open spooled file with TEXT EDITOR and print this...
I'm trying to use SPOOL filename -- SPOOL OUT in SQLPLUS but it dos'nt work. OS- WINDOWS 2000 Pro and Oracle 8i. I decide reason maybe i didn't set up printer to print from DOS application. So I check windows2000 and find solution for setting printer for DOS Application (net use...
I had the same problem before. In my case I create App
lication using MDAC 2.5, but PDW create a package with
MDAC 2.0 So I simple move to lover version and create
the package again.
In ADO Property Sheet go to
Conection Tab
UserName:Admin,
Password: (blank).
Click Tab "ALL" and Edit "Jet OLEDB:DATABASE PASSWORD". Put your password here. That's all.
Previous month I finished with project CRviewer ( Crystal Report Viewer). It use Common Dialog Control for File opening, Crystal Report Print Engine -CRPE.dll, MDI form and Class Module for keeping in Registry List of most recent files. If You are interesting let me know.
In Setup.lst simply delete the line wich request registration of MSFTAWS.PDW. I Had the same Problem. I don't know why Package and Deployment Wizard (PDW)create this line, so i simple delete this line in Setup.lst
txtBox is Name Property of TextBox. So You Place on the Form 5 TextBoxes
With the same Name Property but different Index. The same about OptButton.You set Tag Property for each textbox as below
txtBox(0).Tag = "SpeedCPU" ' 0 is Index Property...
Yes, You can if variable is User Defined Data Type like
Type TaggedVariable
Value as varType
Tag as String
end Type
Dim TagAttay() as TaggedVariable
etc,etc
Use array of TextBox Controls and use Property Tag for texboxes
txtBox(0).Tag="SpeedCPU"
txtBox(1).Tag="OtherCPU"
txtBox(2).Tag="ModelCPU"
txtBox(3).Tag="SNCPU"
txtBox(4).Tag="BrandCPU"
.....
.....
etc,etc
So Property Tag is FieldName in Your...
Const NumOfElm=7
Dim OriginalArray(NumOfElm-1) as String
Dim SortedArray(NumOfElm-1) As String
Dim NewArray(NumOfElm-1) as Integer
Dim IsMin(NumOfElm-1) As Boolean
Dim strMin as String
For i=0 to Ubound(OriginalArray)
IsMin(i)=False
Next
strMin=String(128,"z")
For i=0 to NumOfElm-1...
Do While Not adostaff.EOF
CmbStaff.AddItem (adostaff("fname") & " " & adostaff("sname"))
CmbStaff.ItemData(CmbStaff.NewIndex)=adostaff("staffID")
adostaff.MoveNext
Loop
Later You can find any Item in CmbStaff, using ItemData
For i=0 to...
sql="INSERT INTO ser ("
If NOT Isnull(DTPicker1.Value) Then _
sql=sql & "bus_design_rcvd_date,"
If Not Isnull(DTPicker2.Value) Then _
sql=sql & "assigned_date,"
sql=sql "& priority) VALUES ("
If NOT Isnull(DTPicker1.Value) Then _
sql=sql &...
'IT WILL WORK ONLY WITH MICROSOFT JET ENGINE
For i=1 To 8
For j=1 To 30
Index=(i-1)*30+j
rst.Find "[SNumber]= '" _
& mArray(Index, 2) & "'", , adSearchForward
if NOT rst.Nomatch then _
rst.Fields(5) = i
Next
Next
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.