Search:

can you tell me what is the exact error you are getting so that we can start debuging that

Hi the alias as name you mantion in the recordset.
means you fatche the alias name through the qury .
but you can not generate the alias name in other query , you have to store the value in a temp...

select * from abc where isnuMERIC(Assignment_Id)=0

Use of Sp_dboption



ANSI null default
ANSI nulls
ANSI padding
ANSI warnings
arithabort
auto create statistics

ok i understand the problem that you bind the record set with textbox

so when u add a record in sql then after update it move to the next record.
and the next record is blank.

so please...

1. you just change teh password

2. Remove all the permission (dbowner) for the database

3. Remove the permission from model database so that further it not allocate to any new database created

yes you can trace whta happening in the database or what are the command place in sql


sp_who
dbcc opentran
sql profile
Log file

current login or SPID

Hi jennete

i face the problem when i involved with the datetime.

Please use the FORMAT COMMAND IN vb(book online)

#10/10/2004# , it also help you to search the date

The format command...

:wave: Hi i am back after one year with a expertise in yukon , I Help the forum to upgrade their knowledge in yukon.so guys ready to help ur self and also all to share our knowlege in yukon.
thanks...

to use the database conectivity you must choose the odbc.

from the control pannel choose the obdc then the porvider you want to choose.

biswajit

DayQuery = "select Tno,visitdate from ticket where visitdate = #" & MyDate & "#"



to make it more acurate

DayQuery = "select Tno,visitdate from ticket where visitdate = #" &...

Check the property and locking property of record set
when you open this when it not move then the error is coming
so please check the recordset property

Please you can go through the CDO NT mail.
and it help you a lot and give lot of option.

or you can use Vb inbuilt dll calling outlook express in the run time.and sending mail

Thnaks

you can check it throw two times.

either new or create the getobject .

may be getobject solve your problem

Ok this is one also if you exit the if you check the value and then return=1 then alos your problem can solve

To save the the data in the image type you have to choose the appendchunk and getchunk


then you have tp select the ado for top save and edit the data

To save a image in a datbase thorugh the ado


u can use Appendchunk and getchunck

Hi your error is a genuiune error

Try this code it remove all the error .



Const ERR_APP_NOTRUNNING As Long = 429

On Error Resume Next
Set xlApp = GetObject(, "Excel.Application")

hi

making a database is a trcik things.

if you are making a database in sql server then please concentrate on mdf and ldf file. if they are in separate folder then
your performance is...

hi

about your error please before update or add new you just close the record set .



let i am explain if you open a recordset to add then check it open or not.if it open thne close it.

if you are used in sql server that is

-----> please fill OSQL -SSERVER -USA -PSA.

AND please run the sql sp pack 4 on you computer.

it correct all the thimngs

if you are using the sql server then you use a small syntax that is


sp_tables.


it show you all the datbaae

Biswajit

To acess the last record you have to use the max record.

selec max(filedname) form table


it give you the last record.

Biswajit das

you pass the string

But you did not open the recordset


please write adodc1.open


then no need to extra write the string to refresh the recordset

for resolution you have to create different image in different resolution.

But may be you can use three standard

like 600 800
1024
and some extra


so you consider what resolution your...

if you are use acess database


then open the recordset when you need the use and then pass the connection.

then you close the recordset after you complte your task.


and just make suer...

Please destroy the object after using

set excel.sheet = nothing

it relase the space

if not then incrses you virtual memory
and clean the even viewwer

Crystalreport1.SQLQuery = "Select * from MyQuery"
Crystalreport1.printReportfilename = app.path "&\Project\MyReport.Rpt"
Crystalreport1.activewindow=crptprinter



Jio or jine do

simple codin in two line


Join all the textbox store in a string



then

textbox4.text = format(value,"@@,@@@,@@@@@")

Look to design the database you should


find out the main key in the table
then find out repetable record in the next step


join the single -> with multiple caps.

first one to multi.

Refere sql book for locking things

1, isolation level of connection in vb
2.lock hints in sql servere

3.index in sql
4/sorting in sql


this help you in figuer out locking

Set dbdelete = dbs.OpenRecordset("SELECT * FROM [DVD-ROM] WHERE [ID] = " & ID & " ")


dbdelete.Delete



in string you put the quate and in intger you did not

Your main motivation to fecth the top recored


Plese oreder the record by asc or dsc.

and fetch record by Top syntax in sql query


Biswajit das

Like syntax is case sensitive.

Please refer the IS LIKE opertion also..


or colcae if you requier


Biswajit das

Please refer Mysql gpl version which is free.


i already install a software with gpl version,its work fine

Biswajit das,cheer up

Hi Guys

Its a typical bug in ado.please refer the ado 2.0 , or 2.1 libery.

and where you install your application in the lower os sytstem plese load Mdac also.


I think this will solve you...

please refer the mysql version it give you all the reference .
Biswjit das

Create a blank Database in different sql server.
tehn transefre all the mdf file and ldf file into that place



then run it



Biswajit das

if you want to search inside the record set then

use rs.filter option of the recordset

no need to heat database everytime
Biswajit das

if you call the connection several time then close the connection


if con.state = adsteate then
con.close
end if
and then re open again it