Posts by debasisdas

What you have tried ?

How you restore that from command prompt or directly in mysql ?

He who has never experienced hurt, cannot experience true love.

you need to resize and rearrange the controls based on system resolution. You need to use X and Y coordinates of the screen.

so what are you passing , month name ?

Summon of dark.

Jack of all trades , master of none.

-1162

i think simple subtract will do that for you.

From your post i became a bit curious and tried to trace back my old days here.

My first post was in community introduction section here, as i was trying to post a brief intro of self ,as per the couple of stickies in that section,just to complete formalities ,before being bombarded with questions a lot via PM from oracle and VB 6 forums.

And surprisingly i have started only one other thread Thoughts of the day ,which has over whelming response from members with 1300+ posts.

That simply means i have never asked any question and always replied to others queries/doubts.

So i am going to pat myself on the back the entire evening.

comment Unload Me in your code and i hope the rest wills tart working. use Me.Hide instead of unload Me.

You need to format the date to proper format before pasing the same to database.

what is that CON in your code ?

What type of object is that ?

For that you need to use a staging table and update the master table based upon data in the look up table.

You need to handle the code in a PL/SQL block.

Are you using ADO to connect to the database ?

OS will always print to the Default printer.

that ok, but updating records in a loop is not recommended as it takes a lot of system resources. and you have to commit very frequently , which again has a lot of side effects.

try the following

select * from table_name where status ='Avaibale' and status not in ('Completed','Progress')

a single update statement will do , why you need a loop for that.

then you need to populate records from the source to a staging (intermediate) table before actually inserting them to your main table.

so with each load you need to truncate your table and load only the required records.

"Love is as unproblematic as a vehicle. The only problems are the drivers, the passengers and the road". Franz Kafka

I don't think that is an ER diagram.

That seems to be a flow chart to me.

You need to understand the basis difference bewtwen the two.

i don't think that is VB 6.0 code.

if vb 6.0 then try this

Dim Sql As String = "insert into Customer_tbl (Custsql )values '" & txtFirstName.Text & "','" & txtLastName.Text & "')"
con.begintrans          'con-----ADODB connection object.
con.execute sql
con.committrans

you may not directly update the view , again that depends on your table structure.

The simplest method will be create a view based on the table with last five days record. That will be always refreshed every time you run any query on the view.

once you COMMIT that will be reflected in the database table.

if you exit without commit all the uncommitted transactions will be rolled back.

then you need to push the power button on your computer.

Add a menu item and a sub-menu to the main menu to the form.
Add a picture box to the form and set its visible property to False.

Add the following code to a general module (.BAS).(API Functions)
=================================================

Public Declare Function CreateCompatibleDC Lib "gdi32" (ByVal hdc As Long) As Long
Public Declare Function CreateCompatibleBitmap Lib "gdi32" (ByVal hdc As Long, ByVal nWidth As Long, ByVal nHeight As Long) As Long
Public Declare Function SelectObject Lib "gdi32" (ByVal hdc As Long, ByVal hObject As Long) As Long
Public Declare Function BitBlt Lib "gdi32" (ByVal hDestDC As Long, ByVal x As Long, ByVal y As Long, ByVal nWidth As Long, ByVal nHeight As Long, ByVal hSrcDC As Long, ByVal xSrc As Long, ByVal ySrc As Long, ByVal dwRop As Long) As Long
Public Declare Function ModifyMenu Lib "user32" Alias "ModifyMenuA" (ByVal hMenu As Long, ByVal nPosition As Long, ByVal wFlags As Long, ByVal wIDNewItem As Long, ByVal lpString As Any) As Long
Public Declare Function GetMenu Lib "user32" (ByVal hwnd As Long) As Long
Public Declare Function GetSubMenu Lib "user32" (ByVal hMenu As Long, ByVal nPos As Long) As Long

Add this code to the form load event.
==============================

Picture1.Picture = LoadPicture(app.path & "\" & "CUT.BMP")
Dim D As Long, DU as Long
Dim H As Long
D = CreateCompatibleDC(Picture1.hdc)
H = CreateCompatibleBitmap(Picture1.hdc, 16, 16)

Dim P As Long
P = SelectObject(D, H)
DU = BitBlt(D, 0, 0, 16, 16, Picture1.hdc, 0, 0, &HCC0020)
DU …

Love is like a knife, it can stab the heart or it can carve wonderful images into the soul that will last a lifetime.

A child can ask a question that a wise man can't answer.

follow the link for your question

link

you need to call AddNew or Edit before using Update method.

-1153

"The love we give away is the only love we keep". Elbert Hubbard

you need to convert the date and time to proper format before passing the same to database for processing through SQL statement.

try the sample code

select * from branch
minus
select * from branch where rownum < (select count(*) from branch)

you need to pass the condition in the where clause of the query as per your requirement.

delete deletes the records, which can be made permanent by using COMMIT, and can't be rolled back.

Truncate deletes the rows and resets the high watermark and there by de-allocating all the space allocated to the table.

addnew or edit method of the recordset must be called before the update method.

try as the following code

rs.addnew
rs.Fields("Supplier_id") = Val(Text1.Text)
rs.Fields("Supplier_name") = Text2.Text
rs.Fields("contact_person") = Text3.Text
rs.Fields("contact_no") = Text4.Text
rs.Fields("office_address") = Text6.Text
rs.Fields("emails") = Text7.Text
rs.Fields("website") = Text8.Text
rs.Fields("Fax_no") = Text5.Text
rs.Fields("item_type") = Combo1.Text
rs.Update

you need to use the function REPLACE.

there is no such thing like most recent record in database.

there is no way findout the most recent record.

you need to pass some value to fetch the record.

The query that you are using to frame the query needs to be framed dynamically by input from combo and passed to report.

what exactly you mean by over internet ?

are you in the same network as the server ?

in that case he can certainly use all the available APIs

you need to frame the sql query dunamically and pass the area and get the pincode from database.

"If I love you, what business is it of yours?"

i know that .

what is the sql query you are using

you need to set the password for sys and system users at the time of installation and the scott user account will be initially locked you need tpo log in to system or sys account to unlock the scott user.

that depends on the business logic for which the code is defined.

What i understand from your post is each transaction that is executed on table1 needs to be reflected in table2.

what you need to do is execute the same sql from frontend on table2 as table1.

if using using oracle taht can be simply done by puttin all the DML statement into a block of code in a procedure.

you do not need any code to get the value of barcode in a textbox. Once the barcode reader reads the code the value will be populated on any control having focus. what you need to do is process the value as desired , that might involve some calcuations as per your business logic.