debasisdas

Welcome. I seriously doubt anyone is looking for Dating tips here. Just may not be the right place.

Hi Byoola, Welcome aboard.

lets see your code. and what exactly is the error message ?

have you added composite key on column A and B ?

What company, what are you going to deal with. On which part of this planet ?

So, you want id = routesequence ?

[QUOTE=tomato.pgn;1513846] U can PM me any time u need help[/QUOTE] It is always recommended to post questions and replies in the forum threads so that others also can benefit from them.

For that you need to know how to code in both PHP and MySQL.

How the temporary files being created ? Is it the application that is creating those for any specific reason ? are all those .TMP files or any other binary file ?

inserting from where ? using what to insert ? inserting into what ?

Hi Phil, Welcome to Daniweb.

Which chapter you are talking about ?

What exactly you want to backup and restore ? Images files database ... what ?

1. You need to pass more information. 2. Yes.

You need not open a recordset object to execute an insert statement. try this [code] dbcon.begintrans dbcon.execute strstudinfo dbcon.committrans [/code]

[QUOTE=@Kui;1511057]Hi. i detached the database and added it to my program as an existing item [/QUOTE] What exactly you did ?

[QUOTE=AndreRet;1512419]After all these posts, I see you are using vb.net[/quote] If one goes through this thread, it is quiet clear that the OP has never said what exactly he has really done. But he always pretended to do a lot while he actually did nothing. Nicely he framed his questions …

why you need a separate table for father, mother, sibling. Are not they citizens ? You need to store the info of all the citizen in a single table and then map the data to proper column.

What about using a grid instead.

try this [code]If dr(DbaseExpiryDate) > Format(Now, "MM/DD/YYYYyyyy") Then [/code]

I visited this thread several times in last couple of days, but never had the patience to read 600 + lines of code. May be i will visit this again in the weekend.

Why not use a grid for the purpose.

try this sample [code]select count(*) from demo where user_name = u_name and password = pwd[/code] if this SQL returns 1 log in successful and proceed further else re-prompt for username / password. No need of any looping or checking for EOF.

The root cause is the string function [B]LEFT[/B] in your code. and if [B]CensusBlockID[/B] is a character field it will be even more time consuming. Otherwise using JOIN in place of sub query is good option.

forget about PHP. Post the SQL part of the code where you have any issue.

I don't think this is purely MS SQL code.

Everything always works in development system. Ensure that you are passing the proper file name. Lets know first how you have connected / calling CR from your apps.

No assignments please. We don't spoon feed here.

You can also try using [URL="http://www.codeproject.com/KB/cpp/RC4-BASE64.aspx"]Base64[/URL], also known as MIME encoding, translates binary into safe text. It is used to send attachments in email and to change small bits of unsafe high-character data into stuff that is a lot nicer for text-based system.

Do you have the under lying database in place ?

Yes, I think "real" 3D charts are a bit of a problem. I thought that MSChart could do them, but it seems that the "3D" charts it supports don't have 3 axes. They're just normal 2D (X/Y) charts with a pseudo-3D appearance showing a bit of depth to enhance the …

When oracle is installed it creates a number user almost 20. At the time of installation except the DBA accounts all others are LOCKED by default. Which can be unlocked at the time of installation orlater on by logging in through the DBA accounts. In your case it seems SCOTT …

if you must return some value ,go for a function .

Use must use a dot matrix printer.

[QUOTE=yousuf13;1510729] i want to delete a record by searching that number in two tables Table1 and Table2,the record may present in Table1 or Table2 ,so it should check both the Tables ,if it is found in table1 it should delete or else from table 2 it should delete. [/QUOTE] As …

add commit inside the stored procedure and rerun the same. else commit manually after each execution before running another session, the problem will be solved.

[quote]I want to add a column that shows the number of cupcakes the customer bought for that specific order_date[/quote] I assume you are trying to add that column in SQL output, not in the actual table. Kindly post your table structure and relation between them.

try this [code]SELECT * FROM address WHERE email = 'a@abc.com' [/code]

Are you sure what you want ? COMMAND BUTTON or a PUSH BUTTON ? and what is a PUSH BUTTON ? i have never used that directly on VB form.

show some effort ans show the code that you are working on.

you need to check if the MDB is in sync with the earlier version of database. and ensure that you are passing proper data to the DB from application.

you need to format the date. when you say date between '2/1/2011' AND '2/4/2011' ---system considers this as from 2nd of jan till 2nd of april and i think you want from 1st feb till 4th feb , right ?

Login info must be stored in Database, to enable multiple user with their individual password.

That is the name of the file. and since it is .OCX it is a component. but without knowing more it is difficult to guess what exactly it does.

store all the members in a single table with a spouse column in it.

But how you set the value of the boolean variables ?

How you determine CONTACT and ADDRESS belongs to whom ? Don't you think both should be merged into a single one.

What exactly is the error message ?

If you are using free hand SQL, can use any query.

try this [code] dim my_string as string my_string = "your string goes here..." if my_string = StrReverse(my_string) then MsgBox ("This is palindrome!") end if [/code]