Browse by Tags

Problem with custom SP ...somebody help me

Hi People i have this Sp and i try everything but wen i try to generate the code, nettiers tell me that the sp is not in the correct format. Could please somebody in the nettiers team help me... Thanks!!! this is my sp set ANSI_NULLS ON set QUOTED_IDENTIFIER OFF GO ALTER PROCEDURE [dbo].[_Negocios_AdvancedSearch...

Posted to .netTiers - General Support (Forum) by elfederiko on 04-04-2007
Filed under: .netTiers, Custom Stored Procedure, .net 2.0
Re: Advance Search Problem

I create a custom sp and try to do that search but is a dynamic SQL. And aperently nettiers do not support that kind of sp. Im new in nettiers so what do you suggest i should do? This is the SP. CREATE PROCEDURE [dbo].[_Negocios_Search] ( @Neg_NegocioID varchar(10)='', @Neg_Nombre varchar(100)='', @Neg_Calle...

Posted to .netTiers - General Support (Forum) by elfederiko on 03-29-2007
Filed under: .netTiers, Custom Stored Procedure, Cutom Stored Procedures, .net 2.0
Re: Custom sp expected format. Help Please!

Ok i really don't understand why is the format that nettiers espect os the SP. Please if someone in the nettiers team just tell me what is the problem. Thanks. Here is my sp -------------------------------------------------------------------------------------- CREATE PROCEDURE [dbo].[_Negocios_Search...

Posted to .netTiers - General Support (Forum) by elfederiko on 03-29-2007
Filed under: .netTiers, Custom Stored Procedure, Cutom Stored Procedures, .net 2.0
Bind to First T<List> Entity

Hi, This is a duplicate post but since I'm still searching for an answer I'm posting again. I apologise but I really need to find a solution to this problem. I have a list of Installations, related to an Installation is a list of Images. When listing Installations I want to select the 1st Image of the...

Posted to .netTiers - General Support (Forum) by bevan on 03-26-2007
Filed under: .netTiers, Custom Stored Procedure, ObjectDataSource, Cutom Stored Procedures, Entities, .net 2.0
Custom Stored Procedure returns void?

I have a CSP that does a SELECT and then an UPDATE within a transaction. Unfortunately, it looks like something in this procedure is causing nettiers to generate a method that returns void. I was hoping it would return my particular entity. I got the feeling that the syntax of my procedure is causing...

Posted to .netTiers - General Support (Forum) by csd on 01-10-2007
Filed under: .netTiers, Custom Stored Procedure
Creating Entities from Custom Stored procedures - Help Needed

Hi, I want to generate entities for custom stored procedures along with the entities created from tables & views. I am having a cst file ( Business Object from a Stored Procedure ResultSet ) that will accept a single custom stored procedure as input, and generates the entities. The problem is, i...

Posted to .netTiers - General Support (Forum) by bkar81 on 11-17-2006
Filed under: .netTiers, CreateEntity(), Custom Stored Procedure
Custom stored procedures with dynamic sql returning void

Hi Guys, I've just upgraded from the version 2 beta 2 to version 2.0.0.387. I have several custom stored procs in my app that contain construct sql dynamically and retrun the result by calling EXEC sp_executesql... In the beta 2 version for my procedure "usp_Address_Lookup" .netTiers generated the corresponding...

Posted to .netTiers - General Support (Forum) by Dean_ve on 10-18-2006
Filed under: .netTiers, Custom Stored Procedure, release2.0 problem error
how to code stored procedure calls

Hi There, I'm trying to call my own stored procedure and am struggling. Hopefully somebody can help me? Firstly, I'm developing for framework 1.1 so I'm also using the older 0.9.2 version of nettiers I've managed to discover the (very nice!) Custom Stored proc feature, where you name...

Posted to .netTiers - General Support (Forum) by Brett on 10-11-2006
Filed under: .netTiers, Custom Stored Procedure, Providers
Re: Custom Stored Procedures are being erased.

I initially used "_{0}_" as custom store's format string, tried later with "sp_{0}_" and problems repeats. I create a "Clients" table with "IdClient" , "Name" and "BirthDate" columns. Then i make a custom store named "sp_Clients_Show"...

Posted to .netTiers - General Support (Forum) by ManuX on 06-28-2007
Filed under: .netTiers, Custom Stored Procedure, .net 2.0, SQL
Custom Stored Procedures are being erased.

I have a problem with Nettiers version 2.0.1.471. It's easy to reproduce. 1) Create a table with a column named "colX" 2) Create a Custom Stored Procedure that specify the name of the "colX" in the order by clause (for example) 3) Generate and everything will be OK 4) Drop the...

Posted to .netTiers - General Support (Forum) by nachobornan on 06-25-2007
Filed under: .netTiers, Custom Stored Procedure, .net 2.0, SQL, custom stored Procedured procedure

Page 1 of 3 (21 items) 1 2 3 Next >