Wrox Programmer Forums
| Search | Today's Posts | Mark Forums Read
Welcome to the p2p.wrox.com Forums.

You are currently viewing the section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
Showing results 1 to 25 of 83
Search took 0.01 seconds.
Search: Posts Made By: pankaj_daga
Forum: Access April 12th, 2007, 05:07 PM
Replies: 2
Views: 4,682
Posted By pankaj_daga
Subtraction in an Access Query

Hello everyone,

I need a query where I calculate the net profit (or loss) in the given
transactions. So, I have to sum up all the positive value transactions
and subtract (actually add since the...
Forum: Access January 31st, 2007, 05:53 PM
Replies: 1
Views: 1,158
Posted By pankaj_daga
problem with inserting images in Access report

Hello everyone,

I have a really weird problem while insering images in an Access report.

I have a table where one of the rows contain path to an image on the disk. This may also be NULL, in...
Forum: Access VBA January 7th, 2006, 01:21 PM
Replies: 6
Views: 11,569
Posted By pankaj_daga
passing a parameter to an Access query!

Hi everyone,

I have been trying this for hours and to no avail. I do not know why this should be so difficult!

I have a query in Access say something simple like:

Select * from Employees
...
Forum: Beginning VB 6 April 19th, 2005, 02:27 PM
Replies: 1
Views: 38,514
Posted By pankaj_daga
XML using MSXML2.DOMDocument object

Hi everyone,

I am very new to VBA and XML in general.

I need some help with MSXML2.DOMDocument object. I am using VBA and have the following scenario.

I have an XML structure as follows:
...
Forum: ASP.NET 1.1 February 21st, 2005, 10:12 AM
Replies: 0
Views: 1,504
Posted By pankaj_daga
Visio 2000 on IE

Hi everyone,

I have an ASP.NET application and I want to host Visio 2000 in an IE page. It is an intranet application and all the clients have licence Visio 2000 copies.

On the net, I have only...
Forum: Access September 7th, 2004, 08:48 AM
Replies: 0
Views: 2,804
Posted By pankaj_daga
Access VBA with Oracle connection

Hi everyone,

I am using Access as an interface to an SQL Server database and an Oracle database.

What I do is I insert a new record in an ADODB recordset. Here is how I do it in SQL server:
...
Forum: Oracle September 7th, 2004, 08:47 AM
Replies: 0
Views: 1,800
Posted By pankaj_daga
Access VBA problem with Oracle database

Hi everyone,

I am using Access as an interface to an SQL Server database and an Oracle database.

What I do is I insert a new record in an ADODB recordset. Here is how I do it in SQL server:
...
Forum: Access August 5th, 2004, 04:38 AM
Replies: 0
Views: 1,494
Posted By pankaj_daga
comparing CLOB fields

Hi everyone,

I am using Access to compare records between a SQL Server database instance and Oracle. I have the tables linked and most of the comparisons work fine. I am using joins on the table...
Forum: Access August 3rd, 2004, 06:29 PM
Replies: 0
Views: 1,157
Posted By pankaj_daga
comparing access and Oracle rows

Hi everyone,

I have 2 seperate databases and I need to check for rows that are different from each other in a table. One database is running on SQL Server and the other on Oracle.

I used access...
Forum: Oracle July 9th, 2004, 09:37 AM
Replies: 1
Views: 1,362
Posted By pankaj_daga
Tool recommendation requested

Hi everyone,

Can someone reommend a good and free :D tool that will enable me to visualize the relationship between Oracle tables in a database. I am actually particularyl interested in only the...
Forum: Oracle July 7th, 2004, 05:43 AM
Replies: 2
Views: 4,134
Posted By pankaj_daga
oracle connection string

Hi everyone,

How can I specify a connection string for an Oracle database without a DSN. I want to use the Oracle driver. However, I cannot figure out how to specify it.

I know I can specify it...
Forum: Oracle July 6th, 2004, 02:38 PM
Replies: 1
Views: 1,342
Posted By pankaj_daga
Found out Oracle UPDATE statements do not have a...

Found out Oracle UPDATE statements do not have a FROM clause!

Pankaj
Forum: Oracle July 6th, 2004, 01:21 PM
Replies: 1
Views: 1,342
Posted By pankaj_daga
This statement fails!

[?]

How come this statement fails on Oracle!!

UPDATE TestTickets_T SET TestTicketStatusID=(select TestTicketStatusID from TestTicketStatus_T where InternalName='TICKET_STATUS_IMPORTING') FROM...
Forum: Oracle July 5th, 2004, 10:30 AM
Replies: 1
Views: 3,251
Posted By pankaj_daga
Oracle FLOAT and SQL Server real

Hi all,

A small mapping question. Is the SQL Server data type 'real' equal to Oracledata type 'FLOAT'? I am wondering whether to convert real to float or Oracle number. When I use number, it seems...
Forum: Oracle June 30th, 2004, 04:55 PM
Replies: 1
Views: 1,261
Posted By pankaj_daga
Enable auto numbering in an existing table

Hi everyone,

I have an Oracle table with some data. I want to edit a column in the table to start using auto numbering. I cannot figure out the SQL syntax to do so. I know there is an IDENTITY...
Forum: Oracle June 30th, 2004, 04:55 PM
Replies: 3
Views: 2,213
Posted By pankaj_daga
Hi, I did not have much sleep last night....

Hi,

I did not have much sleep last night. The obvious choice is the DTS wizard built into SQL Server!

Pankaj
Forum: Oracle June 30th, 2004, 11:59 AM
Replies: 3
Views: 2,213
Posted By pankaj_daga
Porting data from SQL Server to Oracle over ODBC

Hi everyone,

I have an ODBC question. I have two databases on the network. One is running under SQL Server and the other is running under Oracle. There is a schema on the Oracle database that has...
Forum: Oracle June 27th, 2004, 12:24 PM
Replies: 1
Views: 1,745
Posted By pankaj_daga
SQLPlus question

Hello,

I am having some trouble with the SQLPlus tool over the command line.

Here is what I do:

on the command line I give the command:
sqlplus /nolog @c:\mycommands.sql

The...
Forum: Oracle June 27th, 2004, 06:59 AM
Replies: 2
Views: 1,215
Posted By pankaj_daga
weird Oracle problem!

Hi everyone,

I am having a weird Oracle problem. I used the command line tool dbca (database configuration Assistant) to create an Oracle database like so:

dbca dbca -silent -createDatabase...
Forum: Oracle June 23rd, 2004, 10:35 AM
Replies: 1
Views: 1,435
Posted By pankaj_daga
Using export and import tool for Oracle

Hi everyone,

I have the problem of migrating an Oracle database to a remote machine and I came across the exp and imp utilities in Oracle and I think that it is the best solution for my problems....
Forum: SQL Server 2000 June 23rd, 2004, 08:51 AM
Replies: 5
Views: 90,645
Posted By pankaj_daga
Rename a table through SQL in SQL Server

Hi everyone,

Does anyone know the SQL statement to rename a table in SQL Server. I want to write a stored procedure that will rename a bunch of tables.

I tried statements like:

ALTER TABLE...
Forum: Oracle June 22nd, 2004, 07:13 AM
Replies: 2
Views: 2,631
Posted By pankaj_daga
Hi Justin, Thanks for replying :-) The...

Hi Justin,

Thanks for replying :-) The version of Oracle is 9i. I think I will have to create a database instance on the remote machine and import the dump file into it, or is there a better way....
Forum: Oracle June 22nd, 2004, 03:26 AM
Replies: 2
Views: 2,631
Posted By pankaj_daga
Create Oracle database using a script

Hi everyone,

I have a question regarding import of an Oracle database using a script. I have an Oracle database running on my system (Windows) and I have to export it to another machine using a...
Forum: Oracle May 24th, 2004, 07:27 AM
Replies: 0
Views: 3,548
Posted By pankaj_daga
Setting NLS_TIMESTAMP_FORMAT global parameter

Hi everyone,

I am trying to set the NLS_TIMESTAMP_FORMAT parameter globally on my Oracle database. I shutdown the database and edit the initialization file that I use during startup. I added the...
Forum: Oracle May 12th, 2004, 04:20 AM
Replies: 1
Views: 25,308
Posted By pankaj_daga
Oracle table name length restriction

Hi everyone,

As you could see from the last few posts, Oracle has been keeping me busy. I am now very close to successfully migrating my SQL Server 2000 database to Oracle 9i.

Oracle has a...
Showing results 1 to 25 of 83

 




Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.