|
The easiest way is to save your first query as a View, then use the View to link into the next query.
eg: The query (fixed up) from your first post is saved as vwBrokerName then do something similar to this:
select tblName.*, vwBrokerName.BrokerName
from tblName
inner joint vwBrokerName on tblName.BrokerID = vwBrokerID
(assuming the ID fields exist in the view and table tblName)
|
|
|
|
|
Hi all,
The application I'm working on is going to be used internationally. So I've loaded up some test data in my SQL Server CE database in fields that are declared as datetime fields. I used American dating when loading them (i.e., MM/DD/YYYY). Now I switched my computer over to UK dating and am searching using UK dating (DD/MM/YYYY). My search date dependent so if search from Jan 1, 2006 through June 2, 2009 I should find an entry that has a date of May 27, 2009. If I'm using American dates and search 1/1/2006 through 6/2/2009 it finds 5/27/2009. But if I'm using UK dates and search for 1/1/2006 through 2/6/2009 it doesn't find 5/27/2009.
I'm not sure if there's something wrong with the way I've declared the fields, with the SQL I use to store the data or with the SQL I use to search for the data. Help?
Denise "Hypermommy" Duggan
|
|
|
|
|
Hi,
assuming your date fields really got declared as DateTime fields, and you use parameterized SQL queries, the only place where it could possibly go wrong is where you parse the user input to turn it into DateTime values; e.g. if you provided a format there, it would use that instead of your regional settings one.
Luc Pattyn [Forum Guidelines] [My Articles]
The quality and detail of your question reflects on the effectiveness of the help you are likely to get.
Show formatted code inside PRE tags, and give clear symptoms when describing a problem.
|
|
|
|
|
Hi
Can anyone tell me how to generate an XML file using a typed dataset?
I have a typed dataset called _WorkStationDataSet. But WriteXml() can not be called direclty from it, I have to create a new instance of it using:
_WorkStationDataSet dsWorkstation = new _WorkStationDataSet(), but then calling WriteXml() on dsWorkstation does not create a hierarchical xml file, instead it just puts two lines of xml at the top of the file showing the name of the dataset.
How do i call WriteXml() on a Strongly Typed Dataset?
Do I need to fill dsWorkstation again once a new instance is created? If yes, how?
Please this is quite urgent
|
|
|
|
|
Make sure the dataset property includeschema = true
Sorry, i meant SchemaSerializationMode = IncludeSchema
Alexei Rodriguez
|
|
|
|
|
Hi
I Just want to know the difference between Network Service Account,Local System Account & Dedicated User Account in sql server 2005
|
|
|
|
|
|
Hi All,
Basically I have a C#.Net Windows Forms application where most of the data is stored in a database (currently SQL Server 2005). Some data that needs storage is file uploads - at the moment I have an FTP setup for transfer of these files to/from a server as and when needed. I also know it is possible to store files in the database (using BLOB's).
I have done the research and found a number of sources that basically agree on one thing - Databases are good for small files ( < 256KB) where as file systems are better for files larger than this. The file uploads in question will most likely be 1MB or larger but can basically be any size.
Anyway, I am posting here because I am looking for some opinions on which option to go for (or maybe another alternative completely). Has anybody had any experience with using either option and can recommend the best route to take?
Thanks for any input 
Life goes very fast. Tomorrow, today is already yesterday.
|
|
|
|
|
I'm a big fan of keeping things simple.
Store your files on a fileserver. Store your data in a database server. 
Think about how you are going to use this files ... will they need to be updated ? Will there be concurrent access to them ? Do you need version control ? Do you need to track who changed the files ?
If your requirements are simple, then go with the simple solution of storing your files outside the database.
That's my vote.
|
|
|
|
|
Thanks for your input
David Mujica wrote: will they need to be updated ?
Will be a case of uploading a newer version, i.e. delete the old, create the new
David Mujica wrote: Will there be concurrent access to them ?
Definitely possible
David Mujica wrote: Do you need version control ?
No
David Mujica wrote: Do you need to track who changed the files ?
Currently the 'uploader' is stored in a Database table along with file name..
Do any of these answers change your mind?
Life goes very fast. Tomorrow, today is already yesterday.
|
|
|
|
|
Based on your input, I still believe I would go with storing the files on a fileserver.
You can control concurrent access to the files by implementing a "check-out/check-in" logic where a user would be required to make a request to "check-out" a file, have him/her edit it and "check-in" the newly revised version.
Using this method you could create a nice audit log of who is updating the files, when the change was made, etc. You could also create a revision mechanism by renaming the old file on the server with an extension of .001, .002, etc
The down-side of this "check-out/check-in" logic is that someone could check out a file and forget to check it back in, causing someone else not to be able to perform their edits. The work-around to this is an administrative override where the first user would loose their "check-out" status and allow the second user to update the file.
|
|
|
|
|
Thanks, a great suggestion. Thou I think I am covered with concurrent users.
Each upload is basically a new file so a file should never even be open before uploaded. Even an edit will be a new file. BTW file uniqueness is achieved with the use of an ID value from the database.
I am concerned with download of a file by multiple uses but I am assuming this is something that is handled with IIS which is providing the FTP support. I will go and look into this now thou...
Again, thanks for your input. An idea I will definitely keep in mind for the future, perhaps if I create my owner server application that handles file transfer (which I guess is a possible solution for my application needs).
Life goes very fast. Tomorrow, today is already yesterday.
|
|
|
|
|
musefan wrote: found a number of sources that basically agree on one thing - Databases are good for small files ( < 256KB) where as file systems are better for files larger than this.
Sounds like a rule of thumb gone mad. It would be crazy to store ISO-files in a database, I'll agree to that. There is no limit in size to determine whether or not to store data in a database; it's more appropriate to consider the type of data and it's usage.
There are various pro's and con's for both;
Pro Filesystem
* Simpler maintenance (manipulating files through Windows' Explorer is easier then SQL)
* Auto-integration into your Google Desktop Search / Whatever filesystem-indexer.
Against Filesystem
* Harder maintenance (filesystem rights, networking issues etc)
Pro Database
* Full-text search available, as well as an easy option for replication
* Ability to add auditing easily, as well as file-comments, tags etc.
Against Database
* Files aren't linked to the Active Directory
* GDS/Windows Indexing Service doesn't look "inside" the database to index your files
For both options; don't forget to add a backup-strategy.
I are troll 
|
|
|
|
|
Thanks, I appreciate your opinions. Here[^] is one article I found in case you fancy a read, it's related to performance between the two (there is a download on the page for .Doc or .PDF).
Personally, I want to go for the file system option as I prefer the idea of the files being stored as files, rather than in a database.
Life goes very fast. Tomorrow, today is already yesterday.
|
|
|
|
|
Thanks for the read
I are troll
|
|
|
|
|
I need help!
My function inserts certain number of rows into dbf with INSERT INTO statement, dbf has 66 fields.
When I insert 983 records it fails with VFP OLE DB Provider error: Variable X is not found, but for less number of rows - aplication doesn't fails.
I think something wrong with my VFP OLE DB Provider. Surfing the Internet didn't help me  (I'have tried to update my provider - didn't help or I did something wrong) .
Did anyone have this issue?
Here is my code:
OleDbConnection oleDbConnection = new OleDbConnection("Provider=vfpoledb;Data Source=" + _tempFolderPath)
string insertCommandText = String.Format("INSERT INTO {0} ({1}) VALUES ({2})",
dataTable.TableName,
columnsList.TrimEnd(','),
arguments.Replace("P", "?,").TrimEnd(','));
int it = 0;
foreach (DataRow dataRow in dataTable.Rows)
{
using (OleDbCommand oleDbCommand = new OleDbCommand(insertCommandText,
oleDbConnection,
oleDbTransaction))
{
for (int i = 0; i < dataRow.ItemArray.Length; i++)
{
if(IsAdditionalSortColumn(dataTable.Columns[i].ColumnName))
continue;
oleDbCommand.Parameters.AddWithValue("@param" + i, dataRow.ItemArray[i]);
}
oleDbCommand.ExecuteNonQuery();
it++;
}
}
}
|
|
|
|
|
Hi
I have a general question about SQL server:
I am running a server that needs a very limited number of user connections (max of 5 at a time). So the 5-CAL edition of SQL 2008 Workgroup seems perfect for me. Now, what I need to know is the following: do I actually need to physically install a CAL on each machine/user that will be using the server (by using I mean reading and writing) or does the 5-CAL licence simply mean that only 5 machines/users will be able to log at any one time?
I.e. can 6 or 7 different people use this as long as only 5 of them are connecting simultaneously?
Thanks
Karl
|
|
|
|
|
There may not be a LMBTFY yet but try this[^], 4-5th result looks promising
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
Lots of general info - unfortunately nothing specific to what I am asking. Thanks for the link though
|
|
|
|
|
I am executing a stored procedure written in oracle from my web page.The procedure has 5 input variable and 2 output variable.But when i am executing the procedure it gives an error.
"ORA-06502: PL/SQL: numeric or value error: character string buffer too small"
i ma using following code,
cmdproc.CommandType = CommandType.StoredProcedure
cmdproc.CommandText = "avlmfg.PROC_TUBE_COIL_LINK"
Dim tub_batch As OracleParameter = cmdproc.Parameters.Add("ls_tube_batch", OracleDbType.Varchar2)
Dim tub_aufnr As OracleParameter = cmdproc.Parameters.Add("ls_aufnr", OracleDbType.Varchar2)
Dim tub_matnr As OracleParameter = cmdproc.Parameters.Add("ls_mill_matnr", OracleDbType.Varchar2)
Dim tub_nos As OracleParameter = cmdproc.Parameters.Add("ln_no_of_tubes", OracleDbType.Int64)
Dim tub_arbpl As OracleParameter = cmdproc.Parameters.Add("ls_arbpl", OracleDbType.Varchar2)
Dim tub_error_flag As OracleParameter = cmdproc.Parameters.Add("LS_ERROR_FLAG", OracleDbType.Varchar2)
Dim tub_data1 As OracleParameter = cmdproc.Parameters.Add("data1", OracleDbType.Varchar2)
tub_batch.Direction = ParameterDirection.Input
tub_aufnr.Direction = ParameterDirection.Input
tub_matnr.Direction = ParameterDirection.Input
tub_nos.Direction = ParameterDirection.Input
tub_arbpl.Direction = ParameterDirection.Input
tub_error_flag.Direction = ParameterDirection.Output
tub_data1.Direction = ParameterDirection.Output
tub_batch.Value = txtChargR1.Text.ToUpper()
tub_aufnr.Value = txtPO.Text.Trim
tub_matnr.Value = txtMatnr1.Text.Trim
tub_nos.Value = schqty
tub_arbpl.Value = arbpl
cmdproc.ExecuteNonQuery()
Thanx in advance,
|
|
|
|
|
souravghosh18 wrote: Dim tub_batch As OracleParameter = cmdproc.Parameters.Add("ls_tube_batch", OracleDbType.Varchar2)
Try adding the length of the varcher2 variable as
OracleParameter = cmdproc.Parameters.Add("ls_tube_batch", OracleDbType.Varchar2, 100)
100 will be the lenght of varchar you have defined in database
|
|
|
|
|
In some fields the parameter length mismatch is happening
Niladri Biswas
|
|
|
|
|
Hi,
I just added full text searching to a table, and the text in the ProductLongDescription column is:
On the go. For all purpose Industrial and Outdoor purposes. Half Hose. Available in Grey or Navy Blue.
When I use the following statement then the record above is returned:
SELECT ProductID_PK, ProductName, ProductLongDescription
FROM tblProduct
WHERE CONTAINS(ProductLongDescription, 'go');
When I use the following statement then nothing is returned, but you can see that "for" is in the sentence as well:
SELECT ProductID_PK, ProductName, ProductLongDescription
FROM tblProduct
WHERE CONTAINS(ProductLongDescription, 'for');
What am I doing wrong? Please can someone help me?
Thanks
Brendan
|
|
|
|
|
Hi Brendan
"a","the","an", "for".. etc are noise words. If you view the Messages can see a information
Informational: The full-text search condition contained noise word(s).
if u execute the same query searching for Outdoor then the query runs properly.
Thanks & Regards
Satish Pai B
|
|
|
|
|
I'm using vs2008 , I try to view multi line at crystalreport textobject as next
<br />
Dim s As String<br />
s = s & "this is first line " & Chr(13) + Chr(10)<br />
s = s & "this is second line "<br />
Dim rpt As New CrystalReport1<br />
<br />
Dim txt As TextObject<br />
<br />
txt = rpt.Section2.ReportObjects("Text1")<br />
txt.Text = s<br />
<br />
but it isn't working ,
it print the text at single line ,, despite of when I export the report to doc file, I fount that it's printed at two lines ..
what can I do
Thanks
jooooo
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
