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 66
Search took 0.01 seconds.
Search: Posts Made By: dhay1999
Forum: Access May 29th, 2007, 03:01 PM
Replies: 2
Views: 1,251
Posted By dhay1999
In case anyone else needs this, I Found it. ...

In case anyone else needs this, I Found it.

CVDATE() function in access

http://support.microsoft.com/kb/210276

Thanks!
Forum: Access May 29th, 2007, 02:03 PM
Replies: 2
Views: 1,251
Posted By dhay1999
Date conversion Issue

I have an access table that has date/times stored like the following...

39198.810243 which according to the report it generates is
4/26/07 7:26:45 PM

is this some form of a julian date?

A...
Forum: Visual Basic 2005 Basics January 3rd, 2007, 01:51 PM
Replies: 3
Views: 1,336
Posted By dhay1999
Thanks for the quick reply. I saw a post...

Thanks for the quick reply. I saw a post somewhere that said that any user can run the application. All you have to do is copy the "application reference" from the start menu to another location. ...
Forum: Visual Basic 2005 Basics January 3rd, 2007, 12:58 PM
Replies: 3
Views: 1,336
Posted By dhay1999
CLICK ONCE AND THE APPLICATION REFRENCE?

I have developed two programs so far in VB2005 (not express). I really love the click once deployment feature. it all seems to work great.

Now to the question...

When the program gets...
Forum: Access May 4th, 2006, 10:12 AM
Replies: 2
Views: 1,050
Posted By dhay1999
Thanks mmcdonal. the Mixed Mode would be best I...

Thanks mmcdonal. the Mixed Mode would be best I think at this point. the thig is that the do need write access, but only via the VB program, this front end will only be used for reporting and...
Forum: Access May 3rd, 2006, 06:23 PM
Replies: 2
Views: 1,050
Posted By dhay1999
Readonly ADP Data

I have a SQL database that the users have Read/Write access via AD and a VB application. I want to set up an ADP project for reports and inquiry selections.

When I set up an ADP it shows all...
Forum: SQL Server 2000 August 24th, 2005, 08:37 AM
Replies: 1
Views: 1,166
Posted By dhay1999
start replication via t-sql

Is there a way to start replication via t-sql stored procedure?

Thanks!
David
Forum: ADO.NET May 3rd, 2005, 06:56 AM
Replies: 3
Views: 2,797
Posted By dhay1999
thanks Peter, but I have no idea what you mean by...

thanks Peter, but I have no idea what you mean by building a hash table. I'll do some research on it, but if you have an example I'd greatly appreciate it!

Thanks!
David
Forum: ADO.NET April 29th, 2005, 09:06 AM
Replies: 3
Views: 2,797
Posted By dhay1999
Dynamic DataAdapter from Typed Dataset

I have a typed DS (xsd) file with numerous tables.

I want to parse through the tables and:

Create a dataadapter for each table
Create the

Something like this...

Sub GetData()
Forum: VB Databases Basics April 5th, 2005, 08:26 AM
Replies: 2
Views: 668
Posted By dhay1999
if textbox1.value >= textbox2.value then ...

if textbox1.value >= textbox2.value then
label1.text = textbox1.value
else
label1.text=textbox2.value
end if
Forum: VB Databases Basics April 5th, 2005, 08:24 AM
Replies: 2
Views: 998
Posted By dhay1999
I don't know why the first one is working, but...

I don't know why the first one is working, but each should be contained in SINGLE quotes IE '20050114' or 'tester'

Double quotes are a VB string thing

In debug your source string should look...
Forum: SQL Server 2000 April 5th, 2005, 08:09 AM
Replies: 1
Views: 2,120
Posted By dhay1999
what about it isn't working the way you like? ...

what about it isn't working the way you like?

Can you get a connection to the remote DB and run a DTS?
Forum: SQL Server 2000 April 5th, 2005, 08:07 AM
Replies: 1
Views: 730
Posted By dhay1999
why don't you just set the unique key to the two...

why don't you just set the unique key to the two fields
d/l request id and PDA index?

no trigger or other code required
Forum: SQL Server 2000 March 9th, 2005, 12:23 PM
Replies: 1
Views: 3,138
Posted By dhay1999
The 64k limit is for a SINGLE SQL string, not the...

The 64k limit is for a SINGLE SQL string, not the entire procedure.

Place GO between statements when possible

Find the big SQL string and alias it if possible.

If you post the code it might...
Forum: General .NET February 23rd, 2005, 03:55 PM
Replies: 0
Views: 1,134
Posted By dhay1999
LLBGEN Help

I am trying to use LLBGEN opensource DAL generator.

I have the classes build, and all the stored procedures.

I am trying to execute a SP with 1 input parm, but I cannot set it via the class.
...
Forum: SQL Server 2000 February 16th, 2005, 09:55 AM
Replies: 8
Views: 10,772
Posted By dhay1999
that is useing 4 part naming, but is unefficient...

that is useing 4 part naming, but is unefficient from what I have read.

here is a sample of how to use OPENQUERY

select * from openquery(as400,'
select * from library.tablename
where ...
Forum: SQL Server 2000 February 14th, 2005, 02:52 PM
Replies: 0
Views: 1,056
Posted By dhay1999
Merge Replication Metadata cleanup MSDE?

I have a bunch (10) MSDE databases that are on merge replication with my SQL2000 box for a particular application.

The merges run quite frequently, and over time the MSMERGE_TOMBSTONE and...
Forum: SQL Server 2000 February 14th, 2005, 02:48 PM
Replies: 8
Views: 10,772
Posted By dhay1999
Setting up AS400 linked server: If you plan...

Setting up AS400 linked server:

If you plan to update the AS400 Journaling must be turned on

Create a System ODBC connection, use an AS400 login whose password doe not expire preferably. Using...
Forum: SQL Server 2000 February 9th, 2005, 10:10 AM
Replies: 1
Views: 3,432
Posted By dhay1999
I found this somewhere, I forget exactly where so...

I found this somewhere, I forget exactly where so forgive me for not giving credit.

put this in your MASTER DB

execute it as an SP passing the parms as defined.

David

--LISTING 3:...
Forum: Access October 11th, 2004, 09:22 AM
Replies: 3
Views: 2,173
Posted By dhay1999
I saw someone once use Microsoft Words spell...

I saw someone once use Microsoft Words spell check some how. He added a couple DLL's and the custom.dic to the project. Might search for that. Wish I could be more help.
Forum: Access October 11th, 2004, 09:19 AM
Replies: 1
Views: 1,421
Posted By dhay1999
that usually means that there is no primary key...

that usually means that there is no primary key defined. Jet requires a PK for positioned updates. If you are trying to update from a query, the underlying/updated table is the one that will...
Forum: Access October 11th, 2004, 09:16 AM
Replies: 2
Views: 921
Posted By dhay1999
try this SELECT [customer].[salesdate],...

try this

SELECT [customer].[salesdate], [customer].[pname], [customer].[refco], [customer].[airline], [customer].[travfr], [customer].[travto], [customer].[outamt], [customer].[tcollect],...
Forum: SQL Server 2000 October 4th, 2004, 10:56 AM
Replies: 3
Views: 3,535
Posted By dhay1999
I created a function to convert my AS400 DB2...

I created a function to convert my AS400 DB2 dates,

CREATE FUNCTION [ufn_AS400Date] (@InDate datetime)
RETURNS varchar(10) AS
BEGIN
RETURN LEFT(CONVERT(VarChar(20), @InDate, 120), 10)
END...
Forum: Access September 23rd, 2004, 03:06 PM
Replies: 1
Views: 937
Posted By dhay1999
http://msdn.microsoft.com/library/default.asp?url=...

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/script56/html/vsfctinstrrev.asp


INSTR function, searches for a string within a string, and returns the position where it starts...
Forum: SQL Server 2000 September 23rd, 2004, 02:50 PM
Replies: 2
Views: 743
Posted By dhay1999
wouldn't the change on insert send another...

wouldn't the change on insert send another transaction back to the source database? or is this a one way transaction?
Showing results 1 to 25 of 66

 




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