If I have a database consist of 2 data file and 1 log file, when I move to a new server and I plan to merge 2 data files into 1 single file only. Can this be done?
Sam.
I run ufsdump cvf /dev/rmt/1 / for a full system backup.
the log show:
Dump: Finished writing last dump volume
Dump: Starting verify pass
Dump: Verification error 9 feet into tape 1
Dump: NEEDS ATTENTION: Do you want to rewrite?: ("yes" or "no" )
What is the meannig of error 9 feet into...
I'm new to unix and I need to perform backup, may I know what is the different for following:
/dev/rmt/0mb
/dev/rmt/0m
/dev/rmt/0c
may I know which is recommended?
Sam.
any "end of file" command to replace current for i = 1 to xxxx method? If I hardcode 100 then program will read first 100 line only:
for i = 1 to 100
fileRead(ll_FileNum, ls_Input) // read import text file
ls_input = trim(ls_input)
dw_1.insertrow(i)
dw_1.setitem (i, 'text1', ls_input)
next...
After adding index key into table, not able to delete record from table.
VB. Net
using below syntax:
Public Function mtdSQLExec(ByVal v_strSQL As String) As Integer
On Error GoTo ErrorHandler
Dim conn As OdbcConnection = New OdbcConnection(g_strConnString)...
I code like below, but I can't get the value. I had tested my stored procedure, it can return value, but not in PB.
Please help!
Sam.
string ls_output=''
DECLARE xp_get_user PROCEDURE FOR xp_get_user @@username=:ls_output output
using sqlca;
execute xp_get_user...
how to get the current window name?
example :
I want to control user to access certain window only, a table will store all window name and user id.
Sam.
I'm using PB6 to connect MS SQL Server with integrated security, that mean use NT authenticate to login to database.
In the application, how to get the NT login id for user?
any sample code? Because I need to create a audit trail table.
Thanks.
Sam.
Sam.
have a multi line edit box, if user key in 3 line, I want to save into 3 different records into a table.
Anyway to substring the text from multi line edit
Sam.
When user login into MS SQL Server, a connection will be created.
If the user close the browser without logoff, that connection still remain there, anyway to prevent this, or I need to write a script to kill it ?
Sam.
How to control no. of row display on the page?
Example : A table have 100 record, I want to display 10 row first, then user click on "next", page will display another next 10 row of record.
How to do this?
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.