|
|
Just a thought....
Since you are building a Calendar/diary program, the database should remain small (~365 entries per year). Since it is small, structures can be parsed at the client with little or no speed issues.
Add a TEXT field to your current sturcture. Fill it with XML.
<ButterFlies>
<ButterFly Type=Monarch Condition=good/>
<ButterFly Type=Moth Condition=poor/>
</BufferFlies>
<WeightLoss>
<FoodEaten Calories=2100/>
<Exercise Task=Running/>
</WeightLoss>
The structures would be easily expanable and upgrades would be simplistic. You will need an XML structure that describes the names & types of what the user wants to collect.
|
|
|
|
|
I am writing a stored procedure, which creates a column using a couple of case statements, it ends up holding an int. Now I need to filter based on that int value, using a variable that is passed into the procedure. I can't seem to do this, because it's not a column in any database. Is there a solution that does not involve temporary tables or a cursor ?
Christian
I have several lifelong friends that are New Yorkers but I have always gravitated toward the weirdo's. - Richard Stringer
|
|
|
|
|
Got it. Added an alias for the result set, and therefore able to reference the column.
Christian
I have several lifelong friends that are New Yorkers but I have always gravitated toward the weirdo's. - Richard Stringer
|
|
|
|
|
Hello all.
I'm going to use MS Data access (MSDAL) application block in my application.
As I know MSDAL is developed for SQL server only, and my application will work
with SQL server and MSDE as well.
So my question is : does MSDAL work correctly with MSDE, is there performance hit. Some body tested it?
Thanks in advance?
Dima S
|
|
|
|
|
MSDE is in effect SQL Server for workgroups. The same System.Data.SqlClient library objects should work equally well for MSDE as SQL Server.
|
|
|
|
|
Hi
I use SQL Server 2000 + MS search service to add a text search capability to an application.
I use CONTAINS keyword to search and the problem that SQL server raises an error (Execution of a full-text operation failed. A clause of the query contained only ignored words.) When the words entered by user contain noise words like (And-or-also-an-another).
How to make the engine ignores the noise words?
OR:
How to get a complete list of keywords and noise words at runtime to filter them?
Notes:
-noise.dat file does not contain all the invalid characters.
-I can't use FREETEXT instead of CONTAINS because It gets awful result with Arabic language (the major language used in the project)
any comments / suggestions are appreciated and welcomed.
|
|
|
|
|
Hello,
I have a dataTable in my database with columns title, category, problem(description of the problem) and solution. I want to develop a good search mechanism for certain problems so that the user can search for problems – solutions, when he quotes a search term. But I think it is not a good search mechanism when the specific problem with solution is only displayed when the user quotes the correct title of the problem. Is there any other possibility, which is not so difficult to implement?
Regards
mat
|
|
|
|
|
I think I can make it with Full Text Search. Does anbody know how the SQL Query String should look like, when I want to retrieve all titles of the dataTable when the quoted search term occurs in the title or the problem description or the solution?
As said my columns are
Title
Category
Problem
Solution
Regards
|
|
|
|
|
Couldnt find moe suitable board. Pls bear.
MySql connection times out after 8 hrs. Anyone else experienced.
There is no spoon.
mail
|
|
|
|
|
Try to check the information from here[^] and let me know whether it is match what you want or not.
A thousand mile of journey, begin with the first step.
APO-CEDC
Save Children Norway-Cambodia Office
|
|
|
|
|
Hye,..what is the datatype for time only.I just want to key in data about time which is 8.00 a.m and so on.
|
|
|
|
|
You should tell us which DBMS that you want to use? In Sql Server the datatype for date and time is datetime. In Ms access you can use Date/Time data type and choose Input mask function from the Field Property place to format your time. If you design an application you should use an activeX control which handle only time input.
A thousand mile of journey, begin with the first step.
APO-CEDC
Save Children Norway-Cambodia Office
|
|
|
|
|
|
How to do the process or read barcode and then convert the data into attributes and save it into table database.(Using Vb 6.0 and MSSQL database server)
|
|
|
|
|
Try to check the information from here[^] and google for more information.
A thousand mile of journey, begin with the first step.
APO-CEDC
Save Children Norway-Cambodia Office
|
|
|
|
|
I'd like to do a bulk insert into a table in a Sybase database, similar to the "bulk insert" command for SQL-Server. I've tried using the input command that I found on Sybase's website:
"Input into Tablename from mysqlfile.sql"
Although, it doesn't seem to like "input" (However the command does work perfectly fine in interactive sql).
I'm using the ExecuteNonQuery method in the OdbcCommand (System.Data.Odbc) class.
Thanks in advance,
Eric
|
|
|
|
|
From memory, "Input Into" is a special command that is handled by directly by the ISQL program (and so is not understood by the database engine).
You might consider using running the Sybase BCP command - although you need to be careful of your %PATH environmental variable if you have MS-SQL installed (because the MSSQL client tools has a DLL that clashes). Other possibilities include using MS-SQL's DTS packages.
Hope this helps.
Andy
|
|
|
|
|
Hello,
I am trying to load Excel data to DataSet, (using OldDb... classes). Unfortunately during Fill method of OleDbDataAdapter OLE looses part of my data. I think that is becouse before loading data JET 4.0 makes some assumptions about what type columns in the sheet are. I think, this is why, when in a column there are some numbers and some strings I can read only numbers or only strings - it depends on which is more frequent.
Is there any way I could make OleDBDataAdapter (or JET driver) to read data as string!
Best regards
Leszek
|
|
|
|
|
Hi there. In your connection string, you can use the IMEX import mode - IMEX=1. Something like this:
string sCon = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\SomeExcelWorksheet.xls;"
+ "Extended Properties=\"Excel 8.0;IMEX=1\"";
You can look at this Microsoft Support document[^] for a more thorough description of the IMEX option.
|
|
|
|
|
Thanks,
this is what I was looking for,
Best regards
Leszek
|
|
|
|
|
Hi !
My application (developped in C++) is using an Access database. The database is actually made of two '*.mdb' files, one being linked to the other with linked tables.
It works fine : I use one database, and I can make SQL queries including the linked tables from the other without any troubles.
My problem now is if I want to install my app on someone else's computer, the path to the databases is different, but the link is absolute. Thus, the linked tables are not found and my application doesn't work.
I know that with Access, there is a menu to update the path of the linked tables, but of course, I don't want to have to do it manually through the Access Application : I want to be able, from my app, to update the linked tables automatically.
Problem : I have no idea if it is possible to do that, and how !
Any help ?
Thanks !
Jerome
|
|
|
|
|
Hi Jerome. I think this Microsoft Support document[^] may have some useful information for you. You may want to look at the Developer Solutions sample program (Solutions9.mdb) referenced in the document.
|
|
|
|
|
Guys,
I have a stored procedure in SQL Server where I pass few parameters like username, email address etc. The stored procedure simply inserts these records into users table that has an identity column as ID. Finally I read the @@IDENTITY variable to read the ID of newly inserted record and returns it via an OUT parameter passed in the stored procedure.
Now question is if I have to call this stored procedure from my C# code, can I used DataReader for this purpose? What are the best practices?
TIA
Jixi
|
|
|
|
|
If you are accessing the newly inserted ID via an OUT parameter then you would use SqlCommand.ExecuteNonQuery().
You could alterantively return the newly inserted ID via a select statement and use a data reader if you want to. e.g. After the insert in your stored procedure you would put
SELECT @@IDENTITY As Identity and you could retrieve that single value using a DataReader, but that is really a bit reduntant because that is what SqlCommand.ExecuteScalar() does for you anyway.
Do you want to know more?
Vogon Building and Loan advise that your planet is at risk if you do not keep up repayments on any mortgage secured upon it. Please remember that the force of gravity can go up as well as down.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
