Posts by debasisdas

your join looks weird.

you are saying 6 tables but actually using 9

as per your code

select * from table1
inner join table2 on table1.id = table3.id

may i know why table1 is joined with table2 on table3.id ?

NOTE:-- There should be at least n-1 number of joins for joining n number of tables.

but to come with any solution, one need to know

1. what is the table structure
2. which all tables are joined in your left outer join
3. what are you doing with the cursor.
4. how many records you are processing ....etc

don't expect others to guess and solve your problem.

which database you are using ?

You only know what you are writing .

lets see the code that you are working on.

which database you are using and what exactly you mean by linking ?

1. clear the control.
2. refresh the recordset from database.
3. populate the control.

This my be helpful to you.

run the command in backend and check if that works for you.

run the query in access.

You need to run one Update query after successful login.

try to run the sql query with the dates that you are passing in the back end and check if you are getting any records.

and ensure to pass the date of DateTimePicker2 less than that of DateTimePicker1

also you need to parse the date into proper format.

if you are using .NET, you should be able to do that.

any ways the dump file will be created with data and time, so should not be a problem if you are storing in a single directory.

You can also add schema name to the file name as well

creation of folder you need handle from your application.

Please read this.

just check if the EXP command works without the batch file.

for /f "tokens=2,3,4 delims=/ " %%a in ('date /t') do set fdate=%%a%%b%%c
for /f "tokens=1,2,3,4,5 delims=: " %%a in ('time /t') do set ftime=%%a%%b%%c%%d%%e
exp userid=DEBASIS_USER/DEBASIS_PASSWORD@DEBASIS_DB file=E:\BACKUP\backup%fdate%%ftime%.dmp log=E:\BACKUP\backup%fdate%%ftime%.log

copy the entire thing and create a batch file.
you need to change the log in credentials.

you can schedule the batch file to be executed as desired using Scheduled Tasks in windows or use your own application.

You can write the back up script into a batch file and schedule to run the same using scheduled tasks or execute from your application.

that is because of the variable names you are using.

since you are using the same variable name for both UPDATE and INSERT, INSERT i s over writing the UPDATE command before it gets executed

try using

$sql_update = "UPDATE orders SET bid='$duma', user_last='$userl' WHERE id='$id'";
$sql_insert = "INSERT INTO bids values ('','$id', '$mid', '$duma','1')";

what is $id in your code ?

just run the SQL part in back end with values and check ,if it works.

post the exact SQL that you are using.

it should be something like

INSERT INTO bids (order,user,bid) values ($id,$userl,$duma);

check your INSERT syntax.

you need to add both the insert and update queries into a procedure and call the same from front end application.

what is the code that you are working on ?

To which version of SQL Server you are trying to connect to using Management Studio Express ?

that will be easy if you calculate at database level.

please read more here.

Which is the PRICE column, in which table ?

please post the table structure only, not all the data in it.

this may help

SELECT DISTINCT
    producten.artnr,
    productlines.prod_id,
    producten.id,
    producten.naam,
    producten.land,
    producten.type,
    producten.kort_omschrijving,
    producten.omschrijving,
    producten.front,
    producten.fles,
    producten.doos,
    producten.metadesc,
    producten.metakey,
    producten.title,
    producten.afbeelding,
    productlines.bedrag
    FROM producten 
    WHERE producten.id IN (SELECT prod_id FROM productlines WHERE price= (select price from productlines)group by prod_id)
    ORDER BY productlines.bedrag

why not select the product with min(price) from second table and fetch that product record from 1st table.

try this

SELECT * FROM ProfilesWebsites LEFT JOIN ProfilesAccounts 
ON ProfilesWebsites.ProfileWebsiteName = ProfilesAccounts.ProfileWebsiteName

what is the source of the data ?

is it from any database ?

You granted from which schema system or HR ?

try this

SELECT  * from empl 
  where  LOWER(REPLACE(replace(replace(replace(replace(drug_name,'.',' '),'_',' '),'-',''),',',' '),' ','')) = 'govindraj'

that is what i said in my post.

it is a sample code so i said check for MySQL syntax.

NOTE :-- the code is in Oracle syntax.

try this sample code

select * from empl 
where lower(replace(translate(ename,'., _-','     '),' ',''))= 'govindraj'

you need to modify the above query to suit your requirements.
also check for MySQL syntax.

what is the query that you are working on.

select count(*) from table1 where name= 'john'

will do that for you.

what is the code that you are working on ?

Why not handle that part using SQL.

Checking data in a loop is going to kill the performance.

To call form2 you must to make an object of form2 :

Dim Myform as New Form2
    Myform.show

NOTE:---Please start a new thread for a new question.

Try using this.

public myform as Form
 myform = New Form1
call thisisasub(myform)

Simply because you are taking the count after adding more records.

have you tried using the NEW keyword.

how i will know what data is in the .csv file

can u post some sample data here.