|
ma se wrote: SELECT RTRIM(Wnr_Name) + ' xxx' FROM tblWineries;
There is a space between the first apostrophe and the xxx...That could be why it is not working?
Paul
|
|
|
|
|
There is a reason for a space between the first apostrophe and the xxx. It is there to separate the two strings. If I were to take away the space, then those with the extra space will only have one space, and the rest will look like:
ABC Wineryxxx
So I I put the space in so that it can look like:
ABC Winery xxx
And some wineries have an extra space, which makes the outcome look like:
ABC Winery xxx
|
|
|
|
|
Hmmm, I see why you put a space before the xxx. Are you sure that the "spaces" are not really ASCII character 255 (which is a blank) by some weird reason? You may want to look at the ascii value of the returned wineries to see if this may be the case.
|
|
|
|
|
hello
have a small problem and want help
i have a domain and a webservice application and i want to connect them toghether and i dont found the good statmet to connect them plz help
thanx
tedy
|
|
|
|
|
hello
have a small problem and want help
i have a domain and a webservice application and i want to connect them toghether and i found the good statmet to connect them plz help
thanx
tedy
|
|
|
|
|
7mam wrote: i want to connect them toghether and i found the good statmet to connect them
Your question doesn’t make a whole lot of sense.
Why cant you run your web service on your domain?
ZeePain! wrote: This seems like one of those programs that started small, grew incrementally, building internal pressure, and finally barfed all over its source code sneakers. Or something.
thedailywtf.com[^]
|
|
|
|
|
|
SQL Server 2000 Enterprise does not work on Windows XP* because it is a server product designed for use in large companies. It is designed to run on a Server therefore the installer will not permit you to install it on a non-server product.
*I modified this so the sentence would make sense as the OP decided to delete the original message and the context was lost as a result
My: Blog | Photos
"Man who stand on hill with mouth open will wait long time for roast duck to drop in." -- Confucious
-- modified at 10:04 Saturday 26th November, 2005
|
|
|
|
|
Given your previous question[^] I am now curious as to where you got Enterprise Edition from. If, only a few hours ago, you were desperate for a free version of SQL Server 2000 did you suddenly win the lottery in order to afford the several thousands of pounds/dollars that Enterprise Edition costs?
My: Blog | Photos
"Man who stand on hill with mouth open will wait long time for roast duck to drop in." -- Confucious
|
|
|
|
|
nice ))).I have it from one years but the problem is because the comuter of witch i shoot install it has windows xp no some of server version so i can't use it.
-- modified at 7:57 Saturday 26th November, 2005
|
|
|
|
|
hi
clous you give me please url of link for downloading of ms sql server 2000 who is free i don't know the exacly additional name of that product.
thank you
|
|
|
|
|
|
But i need sql 2000 not 2005????
|
|
|
|
|
if i download this free version i will can to add my back up from sql2000
???
|
|
|
|
|
You can try it. I'm guessing that it will probably work, but will be a one way operation, i.e. you won't be able to backup the new database and install it on SQL Server 2000
My: Blog | Photos
"Man who stand on hill with mouth open will wait long time for roast duck to drop in." -- Confucious
|
|
|
|
|
thank you but probabry is not enought???
|
|
|
|
|
I think this just represents a different way of working. If I didn't find the documentation that said one way or the other what the situation was then I'd create a little prototype to see what would happen. In otherwords, I'd have downloaded SQL Server 2005 express and attempted to restore a SQL Server 2000 database to it to see if it would work or not.
I guess I take a more proactive approach to getting things done.
My: Blog | Photos
"Man who stand on hill with mouth open will wait long time for roast duck to drop in." -- Confucious
|
|
|
|
|
papa1980 wrote: But i need sql 2000 not 2005????
Search for MSDE. The desktop-edition from SQL-Server 2000 is free, but has some restrictions.
'A programmer ist just a tool which converts caffeine into code'
|
|
|
|
|
Hello I want to insert record in access database using ado.net data adapter , not by command object. by suppling query at run time means Writing Query In a text Box .
Please suggest me.
Manoj
-- modified at 1:45 Saturday 26th November, 2005
|
|
|
|
|
tusar123 wrote: I want to insert record in access database using ado.net data adapter , not by command object.
You do know that the DataAdapter will have a property called InsertCommand that it uses to perform this query. This forms a paradox as it is exactly what you are trying to avoid.
tusar123 wrote: suppling query at run time means Writing Query In a text Box
So, you have a text box on your form. The user will be able to type a query into the text box directly say:
INSERT MyTable(KeyColumn, DataColumn1, DataColumn2) VALUES(1, 'abc', 'def') And then you want a data adapter to run this command?
Why? It would be much more efficient to use a OleDbCommand object instead. You are gaining exactly nothing from the overhead of the DataAdaptor in this instance.
My: Blog | Photos
"Man who stand on hill with mouth open will wait long time for roast duck to drop in." -- Confucious
|
|
|
|
|
I'm trying to create a simple contact manager in Visual Studio 2005 in VB .NET. In VS 2003 you could connect to a database with just a filename, meaning the file will be in the same directory as the executable. VS 2005 doesn't seem to do this. Also, in VS 2003 you could add a connection and drag the tables you want and a connection and data adapters would be created and added to the form designer. VS 2005 doesn't seem to do this either. How would I add a connection to a form. I have a listbox that I could databind, but I would rather have "LastName, FirstName" as the format listed in the listbox. I know how to do that with a sorted list and loop through it and add the key to the listbox. But, if I can't get a connection and datadapter where I can access it in code, I can't do anything. I'm fairly ok programming in vb .net and completely new to VS 2005. Is it possible to do what I asked with Visual Studio 2005?
Thanks
|
|
|
|
|
There is a Database Explorer with VS 2005. Have you tried adding a database connection?
|
|
|
|
|
I added a connection using the tab above the toolbox tab to an Access database. But how do I actually add the connection to the form (or whatever else you do for Visual Studio 2005) to use it and create datasets and data adapters?
Thanks
|
|
|
|
|
I am using Visual C# 2005 Express Edition and there is a tab 'Database Explorer'. I right click on the Database Connections and choose Add Connection from the menu. From there, the wizard walks me through connecting to an Access database. I hope this sheds some light for you.
Paul
-- modified
As far as after connection is in place, you need to tie to a dataset, and data adapter. The data adapter connected to the connection and data set get filled by the data adapter.
|
|
|
|
|
Would like someone to assist me with sample codes used to open a file(a Picture in particular) from a drive in the computer so as to display it on an access form.
Thanks in advance.
ffffffffffffffffffff
|
|
|
|