Top Statement and INDEX= Statement in Datawindow SQL Painter
Is there any way to put TOP and INDEX statement into Sql definition in
Datawindow painter in graphical view.
I know that I can go to "Convert to Sytax" but I want to learn if there is
an option like "DISTINCT" in painter.
Select TOP 100 Name,Surname FROM Names (INDEX = INX_name)
Thanks for all
'Top 100' you can do by making the first item in the select list a computed
TOP 100 Name
I can't think of a way of doing Index.
I never use graphical mode for anything other than very simple queries (and
usually no...SQL statement in datawindow
In my Datawindow painter, I would like to use "LIKE" in the where clause of
my SQL SELECT STATEMENT, but it doesn't seem to show the correct results. I
want to show the results from the database where the input (a retireval
argument) matches anything that's entered close to that entry. I tried
something like this:
SELECT name, address, city, province, postal_code
WHERE name like '%(:name)%';
How can I use LIKE in the WHERE clause where string I am trying to match is
an input retrieval argument?
where name like '%' + :name + '%...Help! How to modify the sql select statement for a nested datawindow inside a composite datawindow?
How to modify the sql select statement for a nested datawindow inside a
Would the following work?
dw_nest.Object.DataWindow.Table.Select="select employee_id from ..."
GetChild () ???
"Jun Gan" <email@example.com> wrote in message
> How to modify the sql select statement for a nested datawindow inside a
> composite datawindow?
> Would the following work?
> dw_nest.Object.DataWindow.Table.Select="select e...SQL statement and If statement
I've problem, it's in sqlcommand it's in "where" condition, which if it's exist in sql the "ELSE" not work, and if the condition not in sqlcommand the "ELSE" appear, could someone help
selectcommand.CommandText = "SELECT Weekno FROM Weeks where Weekno='" + Weekno.Text + "'"
if i delete the condition the " ELSE " appear. otherwise it's not appear
whole code Dim myconnection As New SqlConnection("Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\football.mdf;Integrated S...passing variable to sql statement
could anyone please help me to resolve this issue?
here's my sql query which retrieve last 3 month data
t.execute(SELECT * tbl1 where nmonth >= datepart(mm,DATEADD(month, -3, getdate())) or nmonth <=datepart(mm,getdate()) and empno='"+emppip+"'")
now instead of passing 3 in this query(datepart(mm,DATEADD(month, -3, getdate())) )
i need to pass a variable to retrieve data based on user requirements.
i tried this way,
dim mno as n
t.execute(SELECT * tbl1 where nmonth >= datepart(mm,DATEADD(month, -'"+mno+"'...add sql statement on datawindow
a datawindow is very close to a database table. so i think it's useful to
use sql statement to get data from a datawindow, instead of select data to a
datawindow then save data to a database temp table and then use sql to get
data from it. especially for n tie program,it will be more usefull
I don't really understand this request. I can't think of any reason to
retrieve into a datawindow, then save the retrieved data back into a
database temp table, and then use embedded SQL to re-retrieve the data back
into the application. That's three trips across the ...Passing an array to a SQL statement
I hope someone can help me. I'm using SQL Server 2000 and PB 9.0.3.
I have an application where a user selects one or more reports listed in a
datawindow. I need to run a separate query based upon the selection.
Here's a simplistic example:
report_no IN (selected list)
If I declare a string array report_no how can I pass it to the SQL
You SQL should have a variable of type string array
report_no, report_...nested SQL statements in datawindows
We are developing a N-Tier application for the internet using EA Studio
3.0 and are having a SQL conflict. I am curious if there is a problem
with using a nested sql statement, like th following, as data source SQL
for a datawindow. Now the reason why this is distressing, is due to
the fact that as a sql query I get the desired results, as well as
during a HTML datawindow preview. What seems to happen is when the SQL
statement is nested the retrieval arguments are no longer picked up and
...Passing URL with SQL WHERE statement
Please can someone help with the following? I get this compilation error when trying to pass a specific id from a table in order to see details. When I simply type in the vcid number the code works properly.Description: An
error occurred during the compilation of a resource required to service
this request. Please review the following specific error details and
modify your source code appropriately.
Compiler Error Message: CS1026: ) expectedSource errorOdbcCommand objCommand = new OdbcCommand("SELECT * FROM firms WHERE vcid=<%=Request.QueryString("vcid")%>", o...Getting SQL statement from Datawindow
Is there a way to get the exact SQL statement that will be generated when
dw.GetSQLSelect() returns the statment in this form ...
SELECT xx, yy FROM ...
I am trying to get the statement in this form.
UPDATE xx SET ....
INSERT INTO XXX(xxx) VALUES(xx)....
Have a look at sqlPreview event.
On Wed, 16 Jul 2003 15:52:54 +0900,
Geoffrey Sy <firstname.lastname@example.org> wrote:
>Is there a way to get the exact SQL statement that will be generated when
>calling d...Datawindow from arbitrary SQL statement
I have an SQL statement which executes fine on my host, the results of which
I would like displayed (read-only) in a datawindow.
I can't seem to define a datawindow that has as its syntax arbitrary SQL,
since the DW painter seems to want to be able to "understand" it ... that
is, my statement uses "WITH" clauses, and UNIONs, etc to the extent that is
not graphically representable.
Can I just tell the dw painter "never mind, just run the statement as is and
help me layout the results " ?
Choose Convert to Syntax, then try to ...Passing variable to SQL select statement
I am Using VB .NET:
I need to know how to pass a variable to my SQL Select statement. I generate a Datagrid and in that datagrid there is a hyperlink. I want to beable to click that Hyperlink and pass that value to the select statement.
For instance I have a Hyperlink in the datagrid that show "7023". When I click that It takes me to a new ASP page with the following SQL statement:
"SELECT [tRCableDetails].[EquipmentID] AS 'EID', [tRCableDetails].[SpecificationLength] AS 'Spec', [tRCableDetails].[PhysicalLength] AS 'Physical' FROM [tRCableDetails] WHERE ([tRCable...