by: Chagh |
last post by:
hi all,
how can we have a select satement in an SP?(i want to return a result
set from the SP). i want to migrate from SQL Server to MySQL and i
don’t know what to do with these SPs.
it can be...
|
by: uthuras |
last post by:
hi all,
One of my customer having warehouse database running on DB2. Recently
when they execute the following query at db2 command line
the exepected result take ages before return result
...
|
by: Florian |
last post by:
Hi Uthuras,
it would be helpful to see the access path. However sometimes it makes
sense to rewrite a "not in" to gain better access paths:
I tried the following - hopefully similar -...
|
by: TheSpongebob |
last post by:
Hi,
Here is an example of what I am trying to do. Can I not access (echo or
print or dump to file) the variables within the "BEGIN ATOMIC" ? I get
the error "SQL0104N An unexpected token "ECHO"...
|
by: mstraczynski |
last post by:
Hello,
I've written a procedure that extracts records from the source table
and migrates them into several other tables. For each source record
several records in destination tables have to be...
|
by: yogeeswar |
last post by:
Hi All
I wrote SP with number of delete commands in an atomic block.And there is a possibility of deleting records from parent table before child table so I wrote a handler to handle the...
|
by: Steven |
last post by:
Hello,
In English version of Windows Vista, run a command (for example
icacls.exe) as administrator from Command Prompt, i can determine if the
command successfully executed base on the return...
|
by: Jess |
last post by:
Hello,
The C++ reference says the return result of "copy" is an output
iterator. I'm wondering how I can assign the returned iterator to
some other iterator. I tried
int main(){
string...
|
by: CAG |
last post by:
Hi,
In my application, i'm storing sql query as value of table field in database.
Like in my NewHireEmployee table, value of JoinDateQuery field can be (select hiredate from employeeInfo) or...
|
by: HowHow |
last post by:
Using Access 2000, normally query returns result horizontally. Is there any way to set the query to return result vertically?
For example, my query shown the result as below:
Heading ...
|
by: lllomh |
last post by:
Define the method first
this.state = {
buttonBackgroundColor: 'green',
isBlinking: false, // A new status is added to identify whether the button is blinking or not
}
autoStart=()=>{
|
by: Aliciasmith |
last post by:
In an age dominated by smartphones, having a mobile app for your business is no longer an option; it's a necessity. Whether you're a startup or an established enterprise, finding the right mobile app...
|
by: NeoPa |
last post by:
Hello everyone.
I find myself stuck trying to find the VBA way to get Access to create a PDF of the currently-selected (and open) object (Form or Report).
I know it can be done by selecting :...
|
by: NeoPa |
last post by:
Introduction
For this article I'll be using a very simple database which has Form (clsForm) & Report (clsReport) classes that simply handle making the calling Form invisible until the Form, or all...
|
by: Teri B |
last post by:
Hi, I have created a sub-form Roles. In my course form the user selects the roles assigned to the course.
0ne-to-many. One course many roles.
Then I created a report based on the Course form and...
|
by: isladogs |
last post by:
The next Access Europe meeting will be on Wednesday 1 Nov 2023 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM)
Please note that the UK and Europe revert to winter time on...
|
by: nia12 |
last post by:
Hi there,
I am very new to Access so apologies if any of this is obvious/not clear.
I am creating a data collection tool for health care employees to complete. It consists of a number of...
|
by: NeoPa |
last post by:
Introduction
For this article I'll be focusing on the Report (clsReport) class. This simply handles making the calling Form invisible until all of the Reports opened by it have been closed, when it...
|
by: SueHopson |
last post by:
Hi All,
I'm trying to create a single code (run off a button that calls the Private Sub) for our parts list report that will allow the user to filter by either/both PartVendor and PartType. On...
|
1
